Creating search engine on front sheet

davidyeomans

New Member
Joined
Mar 8, 2011
Messages
1
Hi All,

I am a novice in VBA terms for excel and was really hoping you could walk me through creating something step by step.

I am looking to create a front sheet search engine with either one search text box or multiple drop down standard text boxes to select then press a search button. I want the search engine to search the remaining sheets (may be 50 - 100) where all the data is stored. Each data sheet will share the same layout with data, numbers and drop down box data. Once it compiles the searched data i want it to populate it in a list on the front sheet.

Secondly i would like a similar sheet on sheet two although i want this sheet to act as an upload and save data sheet. For example have standard drop down boxes across the row to fill in the information, once the data is selected i want a save button that allocates the data to it's correct sheet under the last saved entry for that specific sheet.

Can anyone please help me, would be greatly appreciated.
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Forum statistics

Threads
1,222,143
Messages
6,164,178
Members
451,880
Latest member
2da

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top