Help please.
I have approx 60 spreadsheet that are summaries of invoices. They detail the product code, description price and quantity.
I would like to know if there is a formula that I can use to give a total of each product code that appear in the invoices, so I end up with a total order, quantity and price for each item.
Thanks
60 is alot, but if there is some consistent naming for all TABS like Sheet1, Sheet2, etc. then it is possible with an SUM Indirection function. You'll find many examples in the forum like =SUM(N(N(INDIRECT("Sheet"&ROW(1:60)&"!C2"))))
If you TAB naming is not consistent then I would suggest VBA (User defined function)
Last edited by rwgrietveld; 03-11-2010 at 04:30 AM.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
Thanks Ricardo,
The sheets are not actual tabs , but separate worksheets and the number of cells is not consistent - ie on some sheets they will have orderedthat item and not on others.
Do you still recommend your sloution based on this ?
Thanks again
No, Then I would suggest you go towards VBA.
Please note that a Sheet is the same a TAB. The TABs are located at the bottum to go to another Sheet.
In VBA I need to know what you are looking for on all sheets, so please tell us the criteria or upload a wb with a few Sheets.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks