LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 45
Default extracting sheets on the basis of Row character

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting characters before or after a specific character Brian Excel Worksheet Functions 4 April 27th 23 07:42 PM
extracting data to the right of a set character [email protected] Excel Worksheet Functions 8 August 21st 07 08:56 PM
Extracting Data back and forth between Sheets Paul Excel Worksheet Functions 3 July 15th 07 10:16 PM
Extracting cell information from various sheets to a master list JackR Excel Discussion (Misc queries) 0 March 20th 06 02:51 PM
Extracting a character from a string of characters Sue Excel Discussion (Misc queries) 6 October 30th 05 01:35 AM


All times are GMT +1. The time now is 01:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"