user entry form for excel search
 

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

user entry form for excel search
 

there is more than a good chance that this could be done. Just modify/add
code to the code you have in the appropriate places. Look at things like
Inputbox and the Find method (of the range object). Also, looping through
sheets

for each sh in Activeworkbook.worksheets

Next sh

--
Regards,
Tom Ogilvy


"DJTI" wrote:

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