N
Neil_Pattison
I have a spreadsheet for calculating the quantity of materials require
for a job. It starts with a text column for a description of th
material then a calculated column for quantities and then a number o
columns for different work procedures.
Row Number 1 is the names of the procedures and the calulations star
from row 2. Basically in Row 2 the user enters how many procedures ar
to be carried out and it is then calculated to show the quantit
required for each material.
The problem I have is that when I go to copy the formula (to calculat
the quantity) down through all the required cells it doesn't cop
through as I need it to. [eg of formula i
=(A2*J12)+(B2*K12)+(C2*L12)+(D2*M12)+(E2*N12)+(F2*O12)+ etc]
When I go to pull this formula down through the other cells in eac
subsequent it changes t
[=(A3*J13)+(B3*K13)+(C3*L13)+(D3*M13)+(E3*N13)+(F3*O13)+ etc] where a
I need it to stay as (A2*K13)+(B2*K13)+(C2*L13) and so on.
Is there a way where I can copy through all the cells but keep th
formula as (A2*???)+(B2*???) etc
I need to be able to copy them down so that new rows can be added int
the middle of the worksheet and already have the formula in there.
Any help on this would be greatly appreciated. Thank
for a job. It starts with a text column for a description of th
material then a calculated column for quantities and then a number o
columns for different work procedures.
Row Number 1 is the names of the procedures and the calulations star
from row 2. Basically in Row 2 the user enters how many procedures ar
to be carried out and it is then calculated to show the quantit
required for each material.
The problem I have is that when I go to copy the formula (to calculat
the quantity) down through all the required cells it doesn't cop
through as I need it to. [eg of formula i
=(A2*J12)+(B2*K12)+(C2*L12)+(D2*M12)+(E2*N12)+(F2*O12)+ etc]
When I go to pull this formula down through the other cells in eac
subsequent it changes t
[=(A3*J13)+(B3*K13)+(C3*L13)+(D3*M13)+(E3*N13)+(F3*O13)+ etc] where a
I need it to stay as (A2*K13)+(B2*K13)+(C2*L13) and so on.
Is there a way where I can copy through all the cells but keep th
formula as (A2*???)+(B2*???) etc
I need to be able to copy them down so that new rows can be added int
the middle of the worksheet and already have the formula in there.
Any help on this would be greatly appreciated. Thank