ok, I appreciate the title of this post is not going to attract many viewers... but i've a problem, and it's one that is starting to make my eyes bleed...!
so... i guess a brief idea of the situation, and an example will help:
I have a day-to-day spreadsheet with a list of clients, and info on them - so row 1 looks like:
CLIENT NAME / TIER / ASSETS ..........etc
Now, what I want to do, is to have a "summary sheet" in the workbook, which will only show TIER 1 clients and their assets (a bit like a filter, but done automatically, on a separate sheet).
The heading row on the summary sheet would be :
CLIENT NAME / ASSETS ....(plus maybe a few more from the day-to-day spreadsheet)
How should I go about doing this?
Any suggested methods, or basic code I need to be using?
thanks so much guys...
happy weekend!
so... i guess a brief idea of the situation, and an example will help:
I have a day-to-day spreadsheet with a list of clients, and info on them - so row 1 looks like:
CLIENT NAME / TIER / ASSETS ..........etc
Now, what I want to do, is to have a "summary sheet" in the workbook, which will only show TIER 1 clients and their assets (a bit like a filter, but done automatically, on a separate sheet).
The heading row on the summary sheet would be :
CLIENT NAME / ASSETS ....(plus maybe a few more from the day-to-day spreadsheet)
How should I go about doing this?
Any suggested methods, or basic code I need to be using?
thanks so much guys...
happy weekend!
