Copy and paste from column to row

[sburkhar]

Is there a way to copy a formula...........crap, I don't know how to write this....


across the top of my page it looks like this:
A B C D
=C1 =C2 =C3 =C4 etc


Is it possible to copy and paste that formula across the columns? 'cause I have 150 columns.

 

[MDCurry]

Try this.
Assuming your data in C1:C150 at cell D1 paste in formula:

=INDIRECT("C"&COUNTA($C$1:C1))

...and copy across row 1 as far as needed

 

[sburkhar]

I'm sorry, I should have been more clear.
C1:C150 are on another tab. So the formula is actually: =Sheet1!C1 etc

Can you rewrite it for me to encompass that?

 

[MDCurry]

At cell B1 of any sheet other than sheet1 enter formula:

=INDIRECT("Sheet1!C"&COUNTA($A$1:A1)+1)

and copy across.

 

[sburkhar]

excellent!!! it works!
Thanks for writing that for me.