Hi,
I have two workbooks that I am working with, one which contains important data that I need to now analyze in the second spreadsheet. A couple of things to note:
a) the two spreadsheets contain many sheets with the same names where the data needs to be evaluated
b) the same cells need to analyzed from each sheet first spreadsheet in the corresponding cells in the second spreadsheet
If I were to store the workbook and sheet to pull from on each of the sheets where the data will be used in the second spreadsheet, is there a formula that would allow me to update all sheets at once to pull the data from their respective sheets in the first workbook and do whatever to it that I need to do such as summing, counting, percentages, etc.?
Referencing the same cells from unique sheets in another workbook
-
- StarLounger
- Posts: 88
- Joined: 14 Aug 2019, 00:12
-
- Administrator
- Posts: 78487
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Referencing the same cells from unique sheets in another workbook
I don;t think there is an easy way to do that.
You might use a VBA macro to create the necessary formulas.
You might use a VBA macro to create the necessary formulas.
Best wishes,
Hans
Hans