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.
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.
