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.