Hi,
I'm running into a silly question and am hoping to get some help!
I have a spreadsheet that has a list of Name, Region, Company, Date, and Notes.
I've created a user form with different comboboxes where the user can select a specific Name, Region, and Company (based on named ranges) from this list. This is all looking great so far!
Now, once the user has selected these values from the comboboxes, I'd like to have a button that says "Go" which will show a list on a seperate sheet of all notes associated with the users selections. It may be easier to show, so for example give the following data:
<tbody>
</tbody>
In the user form, if the user chooses John & US in the comboboxes, it will show all the meetings and notes on a separate sheet that John had in the US. If the user chooses only Europe, it will show all meetings that everybody had in Europe on a separate sheet.
It seems relatively simple to solve with VBA but I'm running into a wall! I hope I've explained this well enough
I would greatly appreciate some advice and help! Many thanks in advance!
I'm running into a silly question and am hoping to get some help!
I have a spreadsheet that has a list of Name, Region, Company, Date, and Notes.
I've created a user form with different comboboxes where the user can select a specific Name, Region, and Company (based on named ranges) from this list. This is all looking great so far!
Now, once the user has selected these values from the comboboxes, I'd like to have a button that says "Go" which will show a list on a seperate sheet of all notes associated with the users selections. It may be easier to show, so for example give the following data:
Salesperson | Region | Date | Company | Notes |
John | US | 8/1/2013 | Apple | Met with CEO |
Jane | US | 8/1/2013 | Met with CFO | |
Sarah | US | 8/3/2013 | Nike | Analyst meeting |
Jane | Europe | 8/5/2013 | Apple | Product Demo |
John | Europe | 8/1/2013 | Apple | Meeting with team |
John | US | 8/3/2013 | Nike | Met CEO |
<tbody>
</tbody>
In the user form, if the user chooses John & US in the comboboxes, it will show all the meetings and notes on a separate sheet that John had in the US. If the user chooses only Europe, it will show all meetings that everybody had in Europe on a separate sheet.
It seems relatively simple to solve with VBA but I'm running into a wall! I hope I've explained this well enough
I would greatly appreciate some advice and help! Many thanks in advance!