Calculation Macro

[boldcode]

Hi,

I have a worksheet that has row titles in ROW 2 starting from A2 through AR2.My data has thousands of records and always begins in ROW 3. For the purposes of this macro the only columns that matter are "N" through "AR". Column "N" contains numbers that are going to be multiplied against the numbers contained columns "O" through "AR2". So for example cell "N3" will be multipied against "O3", "P3", "Q3", etc...all the way to "AR3" and then "N4" will be multipied against "O4", "P4", "Q4", etc.....all the way to "AR4". Then the same logic will be applied to the remainder of the rows which could sometimes be 1,000 or 10,000 or just some random number of rows.

As part of this post I provide a simple example of what I am looking for in the attached workbook "Book1".


- BC

[stnkynts]

A very good job to you on concisely stating what you are looking for. The example workbook was very helpful. Try:

Please Login or Register  to view this content.

[boldcode]

stnkynts,

It works exactly like I want it to, thanks!

- BC