dragging down formula

[twofootgiant]

Hello,

I have lots of formula pointing to different cell references example:
Quantity
=stations!B$6
=stations!B$7
=stations!B$8
=stations!B$9
=stations!B$10
=stations!B$11
=stations!B$12
=stations!B$13
=stations!B$14
=stations!B$15
=stations!B$16
=stations!B$17
=stations!B$18
=stations!B$19
=stations!B$20
=stations!B$21
=stations!B$22
=stations!B$23
=stations!B$24
=stations!B$25
=stations!B$26
=stations!B$27
=stations!B$28
=stations!B$29
=stations!B$30
=stations!B$31
=stations!B$32
=stations!B$33
=stations!B$34
=stations!B$35
TOTAL:


I need to drag this down so that the formula repeats itself as above...but with C instead of B...then D...then E etc


Any ideas?

[johnjohns]

Type the formula in one cell. Then drag it from left to right. Then copy and Paste Special ->Transpose

rgds

johnjohns