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.

I think the easiest thing may be to just do an Edit|replace
and replace the old worksheet name with the new worksheet name.



Hal LEGERE-Steam Guy wrote:

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.

--

Dave Peterson

Yep, I think yer right, oh well lots of time on a 12 hour night shift in the
old steam plant LOL

"Dave Peterson" wrote:

I think the easiest thing may be to just do an Edit|replace
and replace the old worksheet name with the new worksheet name.



Hal LEGERE-Steam Guy wrote:

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.

--

Dave Peterson

One tip for those long nights. Do a single replace first (not replace all). If
you've typed a worksheet name that doesn't exist, you'll be prompted for the
workbook with that worksheet.

If you have 1000's of links, you'll have to dismiss that dialog 1000's of times
(or kill excel, save your workbook first!).

If you do a single replace first, you can always follow up with a "Replace All"
later.



Hal LEGERE-Steam Guy wrote:

Yep, I think yer right, oh well lots of time on a 12 hour night shift in the
old steam plant LOL

"Dave Peterson" wrote:

I think the easiest thing may be to just do an Edit|replace
and replace the old worksheet name with the new worksheet name.



Hal LEGERE-Steam Guy wrote:

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.

--

Dave Peterson


--

Dave Peterson