![]() |
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