Copy & Paste Formula

[ems.payroll]

I have a supply worksheet that is set up where the new data is added into a new column, so that the report extends horizontally. All of the pricing is in Column I, quantities are listed in the new column, and then totals at the bottom with the following formula:

=(SUM(AF7:AF10)*I7)+(AF12*I12)+(AF13*I13)+(SUM(AF15:AF18)*I15)+(SUM(AF20:AF23)*I20)

When I copy and paste the cell, into the next column for a new order, it changes the quantity column from "AF" to "AG", which I want it to do, but it also changes the pricing column from "I" to "J". I then have to go in manually and change all the J's to I's. When I copy the just the formula, it keeps everything the same, and then I have to manually change "AF" to "AG".

Is there a way to copy and paste so that the pricing column stays fixed within the formula, but the quantity column changes?

[ratcat]

G'day

Try this,

=(SUM(AF7:AF10)*$I7)+(AF12*$I12)+(AF13*$I13)+(SUM(AF15:AF18)*$I15)+(SUM(AF20:AF23)*$I20)

Read this also
http://www.excelforum.com/excel-work...ml#post1963458

HTH

[ems.payroll]

Thanks! That is exactly what I was looking for! This will be a big time saver.

Thanks for the link. I never knew what the $ was used for in the formulas.