Hi all,
I hope i am clear in my explanation. I have Worksheet A and in Cell B2 is a selection of countries prepopulated from a Data Validation List. What i want to do is to find a way for the user to select the country in B2, and then for the company names associated with that country in Worksheet B to display in Worksheet A. For example, let us say Worksheet B has 5 companies in the USA and 3 in Canada. If Worksheet A's B2 cell has USA selected, then in Worksheet A in cell A4 all 5 companies will appear starting with Cell A4 through A8.
IF for example the user selects Canada in B2, then the 3 companies will instead appear. Remember, these company names are pulling from a separate Worksheet (Worksheet B)
I am using Excel 2016 and am reading that VBA code might be needed, which i am ok with but am very new to VBA. Is anyone able to help me in identifying how i can go about this? Sure, i can just have the full list of companies and have the user filter them out as usual, but i am trying to make this look as clean as possible.
Kind Regards,
- Brad
I hope i am clear in my explanation. I have Worksheet A and in Cell B2 is a selection of countries prepopulated from a Data Validation List. What i want to do is to find a way for the user to select the country in B2, and then for the company names associated with that country in Worksheet B to display in Worksheet A. For example, let us say Worksheet B has 5 companies in the USA and 3 in Canada. If Worksheet A's B2 cell has USA selected, then in Worksheet A in cell A4 all 5 companies will appear starting with Cell A4 through A8.
Select Country | USA |
Company A | |
Company B | |
Company C | |
Company D | |
Company E |
IF for example the user selects Canada in B2, then the 3 companies will instead appear. Remember, these company names are pulling from a separate Worksheet (Worksheet B)
Select Country | Canada |
Company X | |
Company Y | |
Company Z | |
I am using Excel 2016 and am reading that VBA code might be needed, which i am ok with but am very new to VBA. Is anyone able to help me in identifying how i can go about this? Sure, i can just have the full list of companies and have the user filter them out as usual, but i am trying to make this look as clean as possible.
Kind Regards,
- Brad