store cell contents and cell address for comparsion & suming

[Guest]

I am trying to in my macro to compare the GL acct #'s in the account column
and on change sum the amounts, using stored range adresses, in total column.

So i need to know how to store and compare cell contentsand cell addresses,
and then how to use the stored address in a sum sttement.

 

[Guest]

Jim,

I have done what you are trying to do, and the best method I have found is
to copy the accounts, cell addresses, and balances into arrays. Then loop
through the arrays to compare the accounts. You can also produce subtotals
using arrays.

If you don't know how to work with arrays, learn! Use Excel help to begin
with. Then post specific questions in this forum. They are extremely
powerfull and fast for working with large amounts of data. Once you get the
hang of them, they are fast and easy to code as well.

Hope this helps.