Prev Previous Post   Next Post Next
  #1   Report Post  
Neil_Pattison
 
Posts: n/a
Default Copying Formula


I have a spreadsheet for calculating the quantity of materials required
for a job. It starts with a text column for a description of the
material then a calculated column for quantities and then a number of
columns for different work procedures.

Row Number 1 is the names of the procedures and the calulations start
from row 2. Basically in Row 2 the user enters how many procedures are
to be carried out and it is then calculated to show the quantity
required for each material.

The problem I have is that when I go to copy the formula (to calculate
the quantity) down through all the required cells it doesn't copy
through as I need it to. [eg of formula is
=(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 each
subsequent it changes to
[=(A3*J13)+(B3*K13)+(C3*L13)+(D3*M13)+(E3*N13)+(F3* O13)+ etc] where as
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 the
formula as (A2*???)+(B2*???) etc

I need to be able to copy them down so that new rows can be added into
the middle of the worksheet and already have the formula in there.

Any help on this would be greatly appreciated. Thanks


--
Neil_Pattison
------------------------------------------------------------------------
Neil_Pattison's Profile: http://www.excelforum.com/member.php...o&userid=27696
View this thread: http://www.excelforum.com/showthread...hreadid=472528

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
adding row to forumla carrera Excel Discussion (Misc queries) 9 August 23rd 05 10:24 PM
Copying a Formula To Reference Multiple Worksheets carl Excel Worksheet Functions 1 August 5th 05 01:06 AM
Copying an Array Formula montagu Excel Discussion (Misc queries) 1 July 15th 05 07:30 PM
Copying Formula Text jpx Excel Discussion (Misc queries) 2 June 8th 05 01:47 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM


All times are GMT +1. The time now is 02:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"