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?

Did you try

Copy the formula cells Right clickPasteSpecialFormulas

If this post helps click Yes
---------------
Jacob Skaria


"Troy" wrote:

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?

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

this data is from another formula. does that matter?

"Troy" wrote:

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?

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.

--
Biff
Microsoft Excel MVP


"Troy" wrote in message
...
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?

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?

"Troy" wrote:

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?

Did you see the reply from Gord Dibben?

--
Biff
Microsoft Excel MVP


"Troy" wrote in message
...
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?

"Troy" wrote:

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?

yes still trying to figure it out

"Troy" wrote:

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?