Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlinking worksheet info to the footer | Excel Discussion (Misc queries) | |||
Need help with automating the updating of a function in worksheet | Excel Worksheet Functions | |||
shortcut for transfering info from one worksheet to another? | Excel Worksheet Functions | |||
Saving worksheet so that merge cells work in previous versions | Excel Worksheet Functions | |||
Updating database worksheet problem (Template Wizard) | Excel Discussion (Misc queries) |