Pasting data in series.

[Kalamari]

Hi, I have a sheet 100X100 numbered 1-100 on each axis (X on row 1, Y in column A, I want the following formula in each cell.

=(X1*4000)/(AX*150) - Where X is equal to the Y and X character of that cell
eg
=(B1*4000)/(A2*150) - This would be the first Cell in my sheet at the topmost upper left empty cell.
=(C1*4000)/(A3*150) - This would be the cell down one and right one from the above cell.

I'm trying to paste the series down the sheet then across the sheet to fill every box but Its pasting every cell as if I want both axis in series, eg

I get..
=(B1*4000)/(A2*150)
=(B2*4000)/(A3*150)
=(B3*4000)/(A4*150)

When I want
=(B1*4000)/(A2*150)
=(B2*4000)/(A2*150)
=(B3*4000)/(A2*150)

Is there any way to fill a series only partially in sequence or else I'm going to have to do 1000 cells by hand.

[singerj6]

Instead of A2 use $A$2 to create an absolute reference

[Kalamari]

Brilliant, thank you.

Modified it slightly using that $ so I ended up with...

=(B$1*4000)/($A2*150)

Then I just drag filled that across the sheet.

Nice to pick up another Excel trick, simply put I'd marry Excel, love it to bits.

[singerj6]

Happy to help, don't forget to mark as "SOLVED"