Copying Sheet 1 to multiple sheets

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

HTML Code: 

On sheet 2 the formula should be

HTML Code: 

but its not, its still

HTML Code: 

So whatever goes into sheet 1 will go into every consequent sheet, whereas i need every sheet to be independant.

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;

HTML Code: 

Can anyone help with the copy paste problem please

Thank you

You could use Find&Replace (CTRL-H) on your second sheet to change Exam1 to Exam2 for all formulae in one operation, then repeat for your other sheets.

Hope this helps.

Pete

Hi Pete,
Thanks, I've tried it and it works, just a shame i have to do it 30 times, thanks for the help.

You're welcome, and thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete