| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find value in more than 100 worksheets at once
Dear Sir,
I have a problem, i want to find a value or number in more than 100 worksheets at once so please help me out. Regards, Alamgir Farooq |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find value in more than 100 worksheets at once
Try this
Go to Edit menu, click Find On the Find Window Click "Options" button and select "workbook" in Within column "Alamgir Farooq" wrote: Dear Sir, I have a problem, i want to find a value or number in more than 100 worksheets at once so please help me out. Regards, Alamgir Farooq |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find value in more than 100 worksheets at once
Irfan's suggestion will work in xl2002 and above.
If you're using xl97 (or any version, actually), you can use Jan Karel Pieterse's FlexFind: http://www.oaltd.co.uk/MVP/ Alamgir Farooq wrote: Dear Sir, I have a problem, i want to find a value or number in more than 100 worksheets at once so please help me out. Regards, Alamgir Farooq -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find across multiple worksheets | Excel Worksheet Functions | |||
| Find sum across all worksheets | Excel Worksheet Functions | |||
| Find Discrepancies between Worksheets | Excel Discussion (Misc queries) | |||
| find formula between worksheets | Excel Discussion (Misc queries) | |||
| How can you find how many worksheets in a workbook? | Excel Discussion (Misc queries) | |||
Hybrid Mode
