Problem
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. |
Problem
On Tue, 15 Jun 2004 08:16:30 -0700, "Jim"
wrote: 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 |
All times are GMT +1. The time now is 11:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com