macro that identifies names of worksheets that have the same value in the same cell

[Iradick]

Hi all!
I need to create a macro that will allow me the following:
i have an excell file that contains 145 worksheets with identical text data (list of chracteristics, for example age 13-17, 18-24, 24-34 etc), and 0 or 1 next to each characteristic. Each worksheet represents diffrent client, 1 next to characteristic means that this client has this characteristic, 0- does not.
the first worksheet is a summary, that sums all these 0 and 1 from all 145 sheets. so for each characteristic i can see how many clients from my list have it.
So what i would like to do to be able to see which exact clients (worksheets names) have charatceristic that i click on.. for example characteristich "age 13-17", a sum next to it is 12, so what is these 12 clients (worksheets names that have 1 and not 0 in this cell).. massage box may be or the better way ...
thank you in advance !

[stnkynts]

Can you submit an example workbook with example data which clearly depicts the before and after of what you are trying to accomplish.

[Iradick]

Sure ! I prepared a file with only 10 clients (i have 145). so on the sheet "Total" I want to be able to see, for example, by clicking on 3 next to characteristic "all", on which 3 of worksheets there is "1" in this cell (client 8, client 9, client 145), or if i need to see who is "female" so i see who is this 7 female clients (have 1 in this cell)..
Hope its clear

[stnkynts]

The attached workbook helped a lot. Select the characteristic you want to report on, in the TOTAL sheet, and run the macro:

Please Login or Register  to view this content.

Note: We can set it up so that when you select the characteristic it automatically gives you the list but I can forsee some issues so I left it as a manual trigger.

[Iradick]

wow!! thank you so much! it works great, can't stop testing this haha ))