Dear Tom and others,

Thanks for the suggestion. Maybe I should clarify a bit more about the
extraction. For example, say I have an excel workbook with 10
spreadsheet pages. In each spreadsheet, there is a dataset such as:

name birthday city
Jack 24 October Utah
Allen 3 March Los Angeles
Mary 15 January Orlando
Kim 9 February New York

The datset in each of the 10 pages is similar to the above but with
different names and other information.

Say in the first spreadsheet, I wanted to extract the whole data line
for both Jack and Kim. In the second spreadsheet, I wanted to extract
the data lines for John and Jeff (it could be any names). And in each
of the spreadsheets, there is a different set of names for which I want
to extract the whole data line. There are numerous data lines for
selected names that I would like to extract throughout the 10
spreadsheets in the workbook.

Is there some way that I could somehow identify or mark (ie. by color or
something) the names or datalines that I want to extract in all the
spreadsheets and be able to extract all those lines in one step to make
a small dataset of all the selected lines in the workbook?

How would you suggest is the best way to do this, especially when there
are nearly 50 spreadsheets with lines of data to extract in the
workbook?

Thanks, and looking forward to your suggestions.

Best regards,

Anne Nasser



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!