Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to search for grouped rows?
Hi,
I have 4 workbooks (for 4 weeks having details on 4 different people), which need to be consolidated into one at the end of the month. Each of these workbooks have details which are grouped thus: Week 1 workbook.xls Person 1 (row grouped for these items below) detail 1 detail 2 detail 3... Person 2 (row grouped for these items below) detail 1 detail 2 detail 3... and so on for Person 3 and Person 4. I have a consolidated xls which has people names, what I need is to open each of the 4 week files and search for the person name, and then copy the grouped rows for that person, say <Person along with the grouped details by using a macro. I found some topics on creating a group, but since I already have them, I need to find grouped rows based on person name and copy them to another consolidated xls. Any help would be appreciated. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to search for grouped rows?
Sorry I forgot to add---some person names in the weekly workbooks do NOT have
any grouped rows at all, but are just one single detail for that person. Hence, I would require the macro to copy the person's details (whether grouped or not) to the consolidated xls. Thanks "Minerva" wrote: Hi, I have 4 workbooks (for 4 weeks having details on 4 different people), which need to be consolidated into one at the end of the month. Each of these workbooks have details which are grouped thus: Week 1 workbook.xls Person 1 (row grouped for these items below) detail 1 detail 2 detail 3... Person 2 (row grouped for these items below) detail 1 detail 2 detail 3... and so on for Person 3 and Person 4. I have a consolidated xls which has people names, what I need is to open each of the 4 week files and search for the person name, and then copy the grouped rows for that person, say <Person along with the grouped details by using a macro. I found some topics on creating a group, but since I already have them, I need to find grouped rows based on person name and copy them to another consolidated xls. Any help would be appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search Columns & Rows | Excel Discussion (Misc queries) | |||
REALLY miussing rows in Excel2000 | Excel Discussion (Misc queries) | |||
Question regarding how to search a column and print a row(s) | Excel Discussion (Misc queries) | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) |