Thread: Find value in more than 100 worksheets at once
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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 With QuoteReply With Quote