formulas copying from sheet to sheet

T

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?
 
J

Jacob Skaria

Did you try

Copy the formula cells> Right click>PasteSpecial>Formulas

If this post helps click Yes
 
T

Troy

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

this data is from another formula. does that matter?
 
T

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.
 
T

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top