Problem

[Jim]

Hi,

I am given a spreadsheet each week which contains two
columns. This first, is a unique reference up to 3
characters long. The second, is a currency value which
relates to column 1.
When I receive the data, I create a number of sums to add
up values of currency for certain groups within the first
column. My problem however, is that the list is getting
very long (up to 20,000) rows, and is never in exactly the
same order, as quite a few unique references in column A
are not in each weeks data!
Is there a way of writing a macro which scrolls through
the list in column A, and capturing the value in column
b? I could then do my sums in the macro for the groups I
wish to total, and assign them to specific cells in my
spreadsheet.
I don’t know if this is possible, but would appreciate
your help.

 

[Ron Rosenfeld]

Hi,

I am given a spreadsheet each week which contains two
columns. This first, is a unique reference up to 3
characters long. The second, is a currency value which
relates to column 1.
When I receive the data, I create a number of sums to add
up values of currency for certain groups within the first
column. My problem however, is that the list is getting
very long (up to 20,000) rows, and is never in exactly the
same order, as quite a few unique references in column A
are not in each weeks data!
Is there a way of writing a macro which scrolls through
the list in column A, and capturing the value in column
b? I could then do my sums in the macro for the groups I
wish to total, and assign them to specific cells in my
spreadsheet.
I don’t know if this is possible, but would appreciate
your help.

Take a look at the SUMIF worksheet function and see if that might do what you
want.


--ron