Creating Worksheets from Mastersheet

Hi everyone,

its not an entirely new problem, however I couldnt find an already existing answer that hepls me.

Basically, as you can see I have a Mastersheet with a list of clients. The following worksheets are of 3 Investors these clients should be attributed to, though not all of the clients should be shown on all investor-worksheets. Hence the idea here is to have Investor 1-3 on the Mastersheet and indicate (maybe by put 1 and 0 in) whether or not a certain client should be shown on a specific investor-worksheet (in form of thes ame table-design as in mastersheet)...so consider the mastersheet to be the complete list, which to some part should be duplicated on the respective investor-worksheets.

Also, clients on the mastersheet are added and/or deleted, so the macro should work fine with that.

Many thanks for any help...

Guys...nobody? If its already solved somewhere, please post a link. Otherwise I assume if you familiar with macros it should def be possible to solve?

Cheers

Konsti,
Your request is not clear.

"Creating Worksheets from Mastersheet"
You have master sheet, so you wish to create tabs for each investor. If my assumption is right, in which row, or column the tabs names are coming from? I think It would be easy for you to include the desired result in your sample,so that any one can see what you are after.

please find attached a possible solution.
On the mastersheet, ALL agencies are listed. It should be possible to select various agencies for teh different investors which should be then put on the respective investor sheets (sheets named "Investor 1","Investor 2", "Investor 3" in my file).

If u check these sheets out, you fet a feeling how they should look like. Important: it should be possible to select a agency more then once. Example: As in my file, Agencie "AAAA" shows up both, on "Investor 1s" sheet as well as "Investor 2"s sheet.

Hope thats more clear...

test_sheet_empty_adjusted.xlsx