Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find text in a protected worksheet | Excel Discussion (Misc queries) | |||
Find text in a protected worksheet | Excel Discussion (Misc queries) | |||
Find text - worksheet function or macro? | Excel Discussion (Misc queries) | |||
FIND A TEXT IN A WORKSHEET NOT IN A COLUMN OR ROW BY FORMULA | Excel Discussion (Misc queries) | |||
Excel: Find/Replace for Data Validation text or Worksheet Objects | Excel Discussion (Misc queries) |