Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How can I create a report that automatically gets data from multiple spreadsheets?
I'm trying to create a statement in excel from a folder of excel files. For example:
#1
I have a file folder with numeral identical invoice excel files.
*in these invoice spreadsheets, all the cell A1 are invoice #s; cells B2:B14 are product codes.
#2
I create a spreadsheet (named:INVOICE STATUS SHEET). It's purpose is to keep track of the invoices and their statuses (like a statement/report).
*Column A in this spreadsheet is invoice #s, Column B is product codes.
Q: How can i make the INVOICE STATUS SHEET(#2) collect the data from all the invoice files(#1) and keep them in sync?
1 Answer
- Anonymous1 decade agoFavorite Answer
One method is to:
Open a "Main" spreadsheet (INVOICE STATUS SHEET) then one of the INVOICE sheets.
starting in a cell that relates to the Invoice Number, enter "=" but DON'T press [Enter]
get the INVOICE sheet in view and click on the INVOICE NUMBER and press [ENter]
The INVOICE NUMBER will now appear in the first "Main" sheet.
As a test you could change the INVOICE NUMBER in the INVOICE sheet and see it change in the "Main" sheet.
Repeat the "=". Open, Click on data, [Enter] process for all the fields you want summarised
You DON'T need to replicate the layout of the INVOICE in the "Main" sheet - it may be simplier to have each INVOICE's data in a single row (but differnet columns) which will help with the likes of sub-totals and totals.
Source(s): Experience