Good evening,
this is my second post. I hope I explain myself correctly.
Sheet 1 Contains no data but formulas
I know how to copy sheet 1 to sheet 2, the problem is that the formulas continue referring to sheet one.
Example:
Sheet 1 Cell C2 Formula is
On sheet 2 the formula should beHTML Code:
but its not, its stillHTML Code:
So whatever goes into sheet 1 will go into every consequent sheet, whereas i need every sheet to be independant.HTML Code:
I need to do this copy/paste about 30 times, so having to manually edit every sheet would be
a pain.
The last sheet would be for example;
Can anyone help with the copy paste problem pleaseHTML Code:
Thank you
Bookmarks