gclearmonth
New Member
- Joined
- Sep 10, 2008
- Messages
- 4
Hello,
I work with a spreadsheet on a daily basis in order to update daily inventory numbers for my firm. The way one sheet is set up is as follows:
September 9
Actual Inventory: X (C5)
Amount on GL: Y (D5)
Difference: X-Y ( E5)
September 8
Actual Inventory: X (G5)
Amount on GL: Y (H5)
Difference: X-Y (I5)
Then, on a separate worksheet in the same workbook, I have labelled "Difference". This is a simple calculation of E5-I5 from the other worksheet. This cell is A5.
Where I run into difficulties stems from the fact that since I do this on a daily basis, I have to insert four rows each day between September 8 and 9. Then what I do is copy/paste September 9 into the blank rows, then change the date for the leftmost "September 9" to the current date of September 10, and replace the values in the September 10 section for today's actual values.
The problem I have now, though, is that when I click on the "Difference" tab, I notice that the cell reference is now E5-M5 (4 columns extra). But I want it to stay E5-I5! I have tried absolute cell referencing but this doesn't seem to work when going between sheets.
Does anyone have any suggestions?
Thanks!
I work with a spreadsheet on a daily basis in order to update daily inventory numbers for my firm. The way one sheet is set up is as follows:
September 9
Actual Inventory: X (C5)
Amount on GL: Y (D5)
Difference: X-Y ( E5)
September 8
Actual Inventory: X (G5)
Amount on GL: Y (H5)
Difference: X-Y (I5)
Then, on a separate worksheet in the same workbook, I have labelled "Difference". This is a simple calculation of E5-I5 from the other worksheet. This cell is A5.
Where I run into difficulties stems from the fact that since I do this on a daily basis, I have to insert four rows each day between September 8 and 9. Then what I do is copy/paste September 9 into the blank rows, then change the date for the leftmost "September 9" to the current date of September 10, and replace the values in the September 10 section for today's actual values.
The problem I have now, though, is that when I click on the "Difference" tab, I notice that the cell reference is now E5-M5 (4 columns extra). But I want it to stay E5-I5! I have tried absolute cell referencing but this doesn't seem to work when going between sheets.
Does anyone have any suggestions?
Thanks!
Last edited:
