Changing Column Location in Excel Formula

[dwg83]

I have a multitude of worksheets that contain the same columns of data, just not always in the same columns. What I intend to do is have a cell dedicated (P1) to entering the number of the column of the data I want to appear in Column P. What do I need to have in my formulae (P2-P1000) in order to refer to the column number listed in P1 and the row value of the current cell?

Thanks
David

 

[stilesbn]

Try putting this in row P2 and dragging it down.

=INDIRECT(CHAR($P$1+64)&ROW(A2))

 

[schielrn]

What are you wanting to do with this data? If you want to sum it, you could do as so:

=sum(offset($a$1,row()-1,p1-1,1000))

I think this may be what you are looking for?

It offsets a1 by the active row - 1 since you are starting in row 1 and then offsets the column by value in p1 - 1 since you start in column 1 and then makes the length 1000?