Index and Match?
I just read your other reply where you say there may be multiple matches and
they could be on more than one sheet.
I can't think of an "elegant" way to do what you want. You may have to do a
separate lookup/extraction for each sheet.
--
Biff
Microsoft Excel MVP
"j.ruderman" wrote in message
...
Somewhat I suppose...Su, Mo, and so on thru Sa, then the following 7
Sheets
are Su2, Mo2 and so on thru Sa2.
"T. Valko" wrote:
Do your sheet names follow some kind of sequential naming pattern? Like
this:
Week1, Week2, Week3
June 2009, July 2009, August 2009
--
Biff
Microsoft Excel MVP
"j.ruderman" wrote in message
...
I have a workbook containing 14 sheets all structured the same. Cells
E8:E39
may contain the text "PS Rep". When that text appears I need to extract
the
text from the adjacent Column F8:F39. I'm tring to do this in a
seperate
sheet, for the entire workbook, in one column without spaces.
Thanks
|