Forum Discussion
How to Copy Formulas From Different Worksheets
I am trying to simplify the inventory sheets we are using to make the process easier. In an excel file, I will have one sheet for each date we take inventory. We create the sheet each week that...
Assuming your periods are 7 days and sheets are named as mmddyy, you may add helper cell
It could be at any place of the worksheet. With that
E3:
=INDIRECT( "'" & $D$4 & "'!" & CELL("address", D3))+1
B12:
=INDIRECT( "'" & $D$4 & "'!" & CELL("address", D12))
I12:
=INDIRECT( "'" & $D$4 & "'!" & CELL("address", G12))drag latest two down.
After you copy/paste worksheet and enter proper date in D2 formulae take data from previous week sheet.
In genera it's more reliable not to reference cell in another sheet but use any lookup function to pickup value based on inventory code. But that will require to restructure sheets a bit.
SergeiBaklan Thank you so much for your help! Truly appreciated!
danazee , you are welcome