I've been trying to find a solution to my problem but I couldn't. I would appreciate your help a lot.
In one sheet I have data about the clients. It contains lots of information, but the most important one are related to client's revenues and advisor's ID. I have approx. 10k clients and 150 advisors.
What I'd like to do is to create a list of advisors and clients related to them. This list should contain client's revenue and industry.
Furthermore, a separate file should be created for each advisor, containing two sheets: one with input (all information about clients) and the other with the list. The aim of this task is to provide an advisor with the list of his clients and relevant information about them.
I have never done VBA before and I guess I will have to use it. Thanks a lot for your help in advance!