Anyone know how to do this? Here is what I mean:

I have about 40 columns across the page that will have data summed up in row
49. I need the totals in row 49 put into a separate chart for calculations.
(i.e. Column C will have numbers in 1-48 totaled in row 49. Same thing for
all columns from C to BZ)

I want to add the column letters, not the numbers, and that is where I have
the problem.

I have the fomula to read "=C49", so that my total in C49 is pulled to where
I want it for further calculations. Then in the next row below needs to read
"=D49" and then "=E49" and so on, so that all the column totals are now in
one column from top to bottom. How do I get fill down/fill series to add the
column letters? When I use fill down, it starts going C49, then C50, then
C51, which is NOT what i want it to do. I need it to read =C49, the D49, ext
to BZ49.

I also have a more complex formula "=ROUND(C49*C5*24,2)", which will be
using the totals I have moved over, and when I use fill down with it, it adds
the numbers as well, so it goes to "=ROUND(C50*C6*24,2)" instead of
"=ROUND(D49*D6*24,2)".

How do get the letters to "increase" but not the numbers? I suspect I will
have to put a $ in front of the numbers, but I have no idea what to do with
the letters.
Any ideas?