Copy and Paste formulas

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!
 
S

Sheeloo

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

Paste Special Values 2
Macro question, Copy-Paste 5
I can't copy and paste equations 0
Paste formulas and keep them the same 7
Copy and paste special 2
UGhhhhh! Why is this so difficult - NO COPY "" 1
Macro to copy & paste-special-values data to selected worksheets 1
Copy worksheet to new doc w/formulas not referencing previous doc 4

Top