I created a workbook that has macros for companies that we email.
Each company is listed on one row on first sheet.
There are buttons for each type of macro next to each company and the interface is getting crowded.
How can I ask the user to select the company when the sheet opens?
This will filter on column A.
Would this be text input match or a drop down?
Or an option box? That might be best.
Then the sheet opens with only their choice showing.
Could someone point me in the right direction on how to create this?
thanks
Each company is listed on one row on first sheet.
There are buttons for each type of macro next to each company and the interface is getting crowded.
How can I ask the user to select the company when the sheet opens?
This will filter on column A.
Would this be text input match or a drop down?
Or an option box? That might be best.
Then the sheet opens with only their choice showing.
Could someone point me in the right direction on how to create this?
thanks