Referencing columns values in row

  • Thread starter Thread starter Pottsz
  • Start date Start date
P

Pottsz

Thanks for the help, but I misstated my earlier question/example. Here's
what I really want to accomplish.
On Sheet A, cells a1:cv100, I want to reference the values from Sheet B,
cells b2:b101. Is there an easy way to accomplish this? On a related note,
I will want to sort the data on Sheet A without disturbing the references
Sheet B.
 
I haven't seen your earlier post, but I think what you want to do is
to put this formula in A1 of SheetA:

=SheetB!$B2

and copy this down to A100. Then copy A1:A100 into columns B to CV.

Sorting usually messes up cell references, but you can fix the values
in SheetA before you sort it.

Hope this helps.

Pete
 

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

Referencing columns values in rows 1
Formula autofill to cells below – formula arguments are cell areas in different columns 1
Referencing help 2
Excel Reference to text returning "0" value on second column 0
Complicated Formula 5
Referencing Data 4
need a macro to append data to a table 3
Referencing sheets 4

Back
Top