I have been very successful with information from http://www.rondebruin.nl
for searching numerous workbooks to pull data into one worksheet. (Thanks Ron!
)
The worksheets have data for different entities, for example I have 20 wells
(entities). Each well has daily worksheets.

The code now asks for a cell range from each worksheet. Is there a way to
have the user enter what well# he wants the data from and the search will go
through all the worksheets and only pull the data for the specified well?

Thanks,
Deb

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200703/1