Macro to Fix Auto-Pattern?

Hi,

The spreadsheet I'm working on is kinda hard to describe, but I'll try.

It's a finance calculator of sorts that I need done, and it shows me the total cost of various products. Each of these products require different components, and numbers of components, and also these components all cost different prices. So what I have is the following spreadsheet setup:

Product | Component A | Component B | Component C |Number of Component A Needed | No. Component B Needed | No. Component C needed

So all I have to do is enter the amount of the component needed and my spreadsheet (this part I've done) multiples the 'Component' by the 'Number Needed.'

Now the thing is that there are quite a few different products, so in the side I've created a universal price list, that shows the prices of all my products. So to get the price of each product I've further created these columns:

Cost Component A | Cost Component B | Cost Component C

And what I want to do is make it multiple the Number Needed * Cost of Component and then be able to use the auto formula to go down the page to autofill these values (since I have about 100, so that would take AGES manually).

So how could I do this? The pseudo code for this patter autofil would be:

Column AA = R[ROW NUMBER]
Column AB = S[ROW NUMBER] * AO14
Column AC = T[ROW NUMBER] * AO15
Column AD = U[ROW NUMBER] * AO16
Column AE = V[ROW NUMBER] * AO17
Column AF = W[ROW NUMBER] * AO18
Column AG = X[ROW NUMBER] * AO19
Column AH = Y[ROW NUMBER] * AO20


And then the pattern as it auto fills would be:
Column AA = R[ROW NUMBER + 1] * AO14
Column AB = S[ROW NUMBER + 1] * AO15


But Excel doesn't put that down as it's auto fill. Instead it decides to do:
[ROW NUMBER + 1] * AO17

ALL the way down... which is wrong. How could I fix this?

Thanks (hope I explained my problem clearly, if not please ask I'll try to clarify
-Rudey