I have a workbook that has 31 worksheets one for each day of the month.
The data in the worksheet if filled in each day so that on day two there is data in sheet one and sheet two but nothing in the other sheets.
I need to bring the most current data from the workbook to a different workbook.
This must be done using formulas no VB allowed.
thanks
Depends on how you have set up your worksheets. One way of doing this is with the help of the INDIRECT formula. The only thing is the workbook from which the data is being picked should be open in-order for the data to be displayed correctly.
So for example, =INDIRECT("'C:\Users\User\Excel Downloads\[ReArrUpdate.xlsm]Sheet"&(DAY(TODAY())-1)&"'!$B$3")
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Posting Permissions
Reply With Quote
Bookmarks