How do I iterate through rows in Excel?

[platypus]

Hello,
I hope you can help. I am using Excel 2003 and have two worksheets set up. Sheet 1 and Sheet 2. Sheet 2 has columns with data set up like below:

A B C D E

In A, there are ID numbers, and there can be duplicate cells in column A with the same ID number. I need to iterate through the rows until I find all cells in column A with, for example, id=432. For each cell in column A with id = 432, I need to get the value in column E and total it up. When that is completed, the result of that total will be inserted into a cell in Sheet 1.

This must be really easy for an experienced coder, but I only do this sort of thing once in a pink moon

Any help with this would be greatly appreciated.

[watersev]

hi, platypus, please post sample workbook showing original data and result you need to obtain

[royUK]

Look at using a PivotTable, you don't need VBA

[pike]

Hi platypus
In sheet 1

Please Login or Register  to view this content.

[platypus]

royUK,

Pivot table won't work because I have to go through a similar process for various other worksheets with different type of data that has to be extracted and inserted into other worksheet.

Thanks, though.

[platypus]

Pike, your solution looks persuasively simple. But I can't give it a go because I just realized that I left my file on another usb stick at uni. Will let you know in 24 hours how it went.

[platypus]

Pike, you are magic! It worked Many thanks!

Hi platypus
In sheet 1

Please Login or Register  to view this content.

[pike]

No Problems