My logical thinking seems to be very fuzzy.
I receive a spreadsheet of Account Customer data which varies month on month.
My VBA code needs to determine each month how many different Accounts are in the list and make a summary list.
I have come up with the code in the attached sample spreadsheet, but I feel that I am over-complicating the issue. Can you help me by either suggesting something simpler, or by validating my approach?
I have attached a truncated file with just the relevant data included.
Thanks very much