Thanks for all the previous help I have received while working on this
project.

Currently I have a macro programmed that takes existing data, inserts
columns, and does equations on the existing data. It copies down each
column and produces a total on the last row. I need to write code in
that takes the cell directly to the left and multiplies it by the
total. For instance:
Cell B1 = A1 * A34
Cell B2 = A2 * A34

Now comes the tricky part. While cell B1 will always pull from Cell A1
and B2 from A2, etc. The row the total is in (in this case, 34) varies
by spreadsheet. In one it might be 34, in another it might be 290.
What is the easiest way to perform this?


--
mkerstei
------------------------------------------------------------------------
mkerstei's Profile: http://www.excelforum.com/member.php...o&userid=25688
View this thread: http://www.excelforum.com/showthread...hreadid=549058