Complex Sort Question

[WealthAdvisor]

New Member and not sure how to do what I need excel to do. I am only reasonably comfortable with vlookup, and I think this will take more functions!

I manage assets for clients and each month import my client data base on sheet1, which has account number and name of client. On sheet 2, is labeled Master Category, in which I assign a number to each client (category) of 1-5 based on risk tolerance. (that could be done with another lookup, but I don't know how to do it with other lookups needed). Another criteria by column is AUM Cient (yes or no).

Now, here's the interesting sort. The monthly imported database of clients shows all current accounts plus new ones added during the month. My sheet labeled Master Category has clients that are no longer with me, the core clients that haven't had a change of status, BUT not the new clients added in the previous month. I need to pull the two sheets of clients together 1) putting the dropped clients on a new sheet; 2) adding new clients and giving them a risk tolerance rank (1-5); and 3) eliminating those that are no long AUM clients (moving them to another sheet).

This is a lot of work I am doing manually. I sincerely appreciate learning how to let excel do most of the work for me and your efforts to contribute to my knowledge.

 

[pplstuff]

So, to make sure I understand correctly... you have two data bases:
1) Monthly Imported
- Contains ONLY current clients (regular clients and client added within the last month)
2) Master Category
-Contains previously recorded clients (regular clients and those who may have removed all assets under management with the last month)

If that is correct, do you want to update you Master Category database? Or, create a new database?

 

[WealthAdvisor]

Yes, that is correct. On the Master Category db, I have to 1) remove those that no longer use my services, and 2) add new members from the imported db that contains the core group and new member accounts.
Gerry