Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming |