formula won't change correctly when dragged
OOO never mind I figured it out!!!!!!!! Thanks bunches!
"T. Valko" wrote:
Assume you want the formulas entered starting in cell A1...
=INDEX('5West'!F$33:J$33,ROWS(A$1:A1))
Change J$33 to reflect the actual end of the range you're using.
--
Biff
Microsoft Excel MVP
"Meenie" wrote in message
...
In Excel 2003:
I have this formula: ='5West'!F33 and I want to drag it down to the cell
below this one and have the column reference ("F") change but not the row
reference ("33") so the new formula would be: ='5West'!G33. But instead it
changed the number and not the letter.
If I make the formula: ='5West'!F$33, then it drags the formula down as is
and still doesn't change the letter. How can I make it change the letter?
Thanks
|