I had a worksheet (please see attached) with 2 columns -- column A is list of "volunteers" and column B is corresponding donations solicited. I need to get a list all volunteers, do a count of how many donations each one solicited, and the total amount each one solicited.
Following is my code:
This macro doesn't work in real life situation, where I would not know in advance how many "unique" volunteers there are. The formulae in the macro are totally useless since hardcoding the criteria (volunteer initials) would not be possible.Please Login or Register to view this content.
Shall very much appreciate if some one can give help me out.
Thank you very much
Henry
Bookmarks