How to add numbers to address

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
 
A

A.W.J. Ales

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 *
 

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

Section and Page numbering 0
Finding the proper style field and the numbered paragraph value within the style 0
How can the font and size of (all) citation numbers be altered? 1
Finding the right style field in VBA 0
Macro to add Multiple rows in same sheet 1
Data Validation and drop-down list using IF, AND and what else? 8
lookup and return column number 2
How to replace text with numbers? (formula) 4

Top