extracting sheets on the basis of Row character

[Radhakant Panigrahi]

Hi,

I have the below data...i have only shown the st column but i have the data
in 15 coulmns. Like this i have 20 sheets... and i need a separate sheets for
the name that are contained in column A ie separate sheet for "Mark" where it
will extract the data from 20 sheets where there is row with name mark...

Name
Mark
Steve
Mark
Gary
Mark
Gary
Steve


Regards,
radha

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.