ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Updating Info from a previous worksheet (https://www.excelbanter.com/excel-worksheet-functions/104403-updating-info-previous-worksheet.html)

Tara working away

Updating Info from a previous worksheet
 
I have a worksheet that shows "mileage" such as 999999 and I will manually
update on a new worksheet todays mileage #, I have a space commited to show
the amount of "miles" traveled in the 2 day span. (that parts all good). ow
my problem is that I need it to update the place it is going to pull the #
from (previous days worksheet) how do I do that so it pulls from the previous
worksheet automatically? Here is what the formula looks like: =H8-'7-31 &
8-1'!H8 then for the next worksheet I need it to look like this: =H8-'8-2 &
8-3'!H8

Any help is apreciated.. is this even possible?
Thanks!


All times are GMT +1. The time now is 12:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com