Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 27th 06, 05:53 AM posted to microsoft.public.excel.worksheet.functions
Minerva
 
Posts: n/a
Default 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   Report Post  
Old June 27th 06, 06:18 AM posted to microsoft.public.excel.worksheet.functions
Minerva
 
Posts: n/a
Default 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
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
Search Columns & Rows mully Excel Discussion (Misc queries) 1 February 3rd 06 11:38 AM
REALLY miussing rows in Excel2000 Geoff Lambert Excel Discussion (Misc queries) 2 July 21st 05 03:20 PM
Question regarding how to search a column and print a row(s) Max Excel Discussion (Misc queries) 0 July 15th 05 04:14 AM
flexible paste rows function that inserts the right number of rows marika1981 Excel Discussion (Misc queries) 1 February 18th 05 02:40 AM
Row selections by row # OR by even/odd rows in another spreadsheet Tom Excel Discussion (Misc queries) 0 February 9th 05 04:03 PM


All times are GMT +1. The time now is 01:38 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017