How to add numbers to address

  • Thread starter Thread starter RonGor
  • Start date Start date
R

RonGor

How to add numbers to address: I'm trying to build a matrix where the
each colum represent the 7th colum from another worksheet. For example
Col A should have the value from the ather work sheet A1, B should have
A7, C have A13 Etc. How do I do that. Thnks for your help
 
Suppose the active cell is on sheet2 and the values you want to take are on
sheet1.
Then put =INDIRECT("sheet1!A"&1+6*(COLUMN()-1)) in cell A1 and copy rigth
to B1 ; C1 etc.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top