bringing data from a column to a row in a formula

H

Hulk

Yes, I dont want to just copy the information, i want the formula t
move from say c18 to c19 to c20 down the same column, but differen
rows....
Using the $ in front of the C will do it when i'm on the sam
worksheet, but won't work on data from another workshet
 
D

duane

if I understand you correctly you want to get a row of formulas such a
=c1, =c2, =c3 etc.

you can construct this by something like

=INDIRECT("c"&COLUMN()-x)

copied across = adjust x to get you the first row right, and the ro
will then increment as you copy across columns
 
Top