Hi MrExcel,
I need help in copying a worksheet formula
from one worksheet to another but have it reference the prior worksheet... ex.
Aug02 worksheet ending balance for cell "C10" is $100. I then use "Move or Copy" function to create a copy of the current worksheet and rename it Sept02.
Sept02 beginning balance would be
(=+'Aug02'!C10) display a balance of $100.(correct). Now Sept02 ending balance is $500. I then use the "Move or Copy" function to create a copy of the current worksheet (Sept02) and rename it Oct02.
Now here's my problem.... the Oct02 beginning balance is referencing (=+'Aug02'!C10)August ending balance of $100 instead of
September ending balance of $500.
Help... How to I setup up my worksheet correctly.
Darnell
I need help in copying a worksheet formula
from one worksheet to another but have it reference the prior worksheet... ex.
Aug02 worksheet ending balance for cell "C10" is $100. I then use "Move or Copy" function to create a copy of the current worksheet and rename it Sept02.
Sept02 beginning balance would be
(=+'Aug02'!C10) display a balance of $100.(correct). Now Sept02 ending balance is $500. I then use the "Move or Copy" function to create a copy of the current worksheet (Sept02) and rename it Oct02.
Now here's my problem.... the Oct02 beginning balance is referencing (=+'Aug02'!C10)August ending balance of $100 instead of
September ending balance of $500.
Help... How to I setup up my worksheet correctly.
Darnell