Copy and Paste formulas

  • Thread starter Thread starter GG
  • Start date Start date
G

GG

I have cells A1:A12 with data on one worksheet. I am trying to reference
these same cells on a different worksheet in B2:M2. I undertand the
transpose option in paste-special, but I can not make this work to copy a
formula.
Help!
 
When you copy and paste formulae in Excel, references are adjusted unles they
are absolute references.

Add a $ in front of Col letters in the formulae in Col A
eg if A1 has =C10 change it to =$C10
then copy A1:A12 and PASTE SPECIAL and check Formulas and Transpose both
before pasting in B2
Then search and replace = with =Sheet1! after pressing ' to toggle to
formula view
 

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

Similar Threads

Copy and paste special 2
Help with formula 4
Paste Special Values 2
I can't copy and paste equations 0
Copy and Pasting Formulas 4
Copying Formulas 2
Macro question, Copy-Paste 5
Copy absolute formulas 1

Back
Top