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 !
Bookmarks