formulas copying from sheet to sheet

[Troy]

I'm trying to copy a group of formulas from one sheet to another. The
formulas being copied are a simple restating of data. example Cell 3AA =
cell 3A.

When I copy and paste the group of formulas like this on the next sheet, the
formuals are still referencing the data on the previous sheet instead of the
sheet.
that was just pasted to.

How do I paste these formuals on each sheet referencing the data in that
sheet?

 

[Jacob Skaria]

Did you try

Copy the formula cells> Right click>PasteSpecial>Formulas

If this post helps click Yes

 

[Troy]

yes. same thing happens. keeps referencing cells on the intial sheet.

this data is from another formula. does that matter?

 

[T. Valko]

I see you're using the MS Discussion groups website.

Scroll down the questions page and look for the thread titled: Copy Formulas
Only. It's near the bottom of page 1.

 

[Troy]

I saw that, but I want to copy several formulas at a time and paste to
several new sheets. Doing it that way would take forever.

Is there no other way?

 

[T. Valko]

Did you see the reply from Gord Dibben?

 

[Troy]

yes still trying to figure it out