• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Level - Difficult: Export from Quickbooks to Excel - However.......

M

mwachsler1

New Member
What I want to do basically, is to take the TOTAL from the Quickbooks report and have it end up in a certain cell in an already existing Excel worksheet. I tried to 1st export the report to a new worksheet and have the existing worksheet automatically copy the TOTAL from the new worksheet. The problem is that the TOTAL in Excel ends up in a different cell every week. (Reason being - For ex: the number of customers that owe money vary from week to week, so if 2 people owe money the TOTAL will be in cell #3 but if 3 people owe money then the TOTAL will be in cell #4 etc....)

How can I resolve this issue?
 
Have to wait for them to reply unfortunately. They might be working on it right now. they will probably need more details though about your problem
 
Hi, mwachsler1!


I don't realize what exactly are you referring as "Quickbooks report". Is that a type of sofware, certain file extension, a brand Excel workbook, or just a file which you give that name?


I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).


Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.


Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, well, come back here, tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.


Consider uploading a sample file so as to make things easier for people who may help you.

Give a look at the second green sticky post at this forums main page for uploading guidelines.


Regards!


@Montrey

Hi!

Nothing about "working on...", just a day outside the city on a vessel :)

Regards!
 
Quickbooks is a bookkeeping/accounting software for businesses to keep track of everything going on - invoices, bills, accounts receivable etc..... You can also make reports/statements using this software. For example: If u want to know exactly who owes you money and how long ago the payment was due. you just create a report/statement. This software allows you to take the reports you have and export them to excel.

Basically, all you have to answer is, how can I have - for ex: - cell A1 pick out a TOTAL# from a different excel sheet automatically if the TOTAL# will be be - for ex - in cell F5 the first week and in cell H10 the second week - without redoing any formulas. (Maybe a formula that will tell excel to always choose numbers that are at the most bottom-right part of the page being that my TOTAL# always ends up at the bottom-right,just in a different cell every week).I hope I explained it well :) Thanks
 
You must log in or register to reply here.
Back
Top