| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Past Link then copy
I am doing a log sheet which calculates usage of gas and steam production on
a daily basis. The readings are taken daily and the usage/production is calculated. I want to automatically transfer the previous day's readings to the next day's sheet so that I don't have to retype the readings twice. I have done a "paste link" to the next worksheet and would like to find an easy way to copy the sheets so that the "paste link' will refer to the last days sheet rather than refer all the way back to the original sheet. I there a way to copy sheets which will increment the sheet reference in the "paste link" formula to the previous sheet. I am a lazy guy and don't want to edit every "paste link" to the previous sheet as ther are 365 days every year and about 10 cells per day which need to carry over. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) | |||
| How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
| How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) | |||
| copy paste cell character limit | Excel Discussion (Misc queries) | |||
| most effective way to link ms word tables to excel | Excel Discussion (Misc queries) | |||
Threaded Mode
