View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sundar Sundar is offline
external usenet poster
 
Posts: 4
Default Find text and print its corresponding worksheet name and row

Hi all,
I have around 30 worksheets. Each work sheet has some values in it. Around
10 to 1000 rows of data in each sheet. Now, I have to find a text called,
say, "apple" in all the sheets and print the sheet name, and rows values in
the 31st sheet.

I hope the above explanation is understandable.

Thanks in advance.
Regards,

Sundar