Index and Match?
That is where i'm running into problems. The text may, or may not, appear
mulitple times per sheet and in mulitple sheets.
"Shane Devenshire" wrote:
So what do you do if the text PS Rep appears on two sheets or more than once
in one sheet?
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"j.ruderman" wrote:
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
|