| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
extracting sheets on the basis of Row character
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. -- Don Guillett Microsoft MVP Excel SalesAid Software "Radhakant Panigrahi" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting characters before or after a specific character | Excel Worksheet Functions | |||
| extracting data to the right of a set character | Excel Worksheet Functions | |||
| Extracting Data back and forth between Sheets | Excel Worksheet Functions | |||
| Extracting cell information from various sheets to a master list | Excel Discussion (Misc queries) | |||
| Extracting a character from a string of characters | Excel Discussion (Misc queries) | |||
Linear Mode
