Take values from Worksheet A and place them in Worksheet B based on cell value

[Ebiru2387]

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.

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

 

[JLGWhiz]

Hi @Ebiru2387 - Just some advice on posting. Other members of the forum cannot see your worksheets, so it is imperative that you either post an image of your worksheets (see paper clip icon at lower left of reply box, or use xl2bb image painter), or give a complete narrative description of where your data resides by column and/or row. I don't know anyone who is capable of ESP and can determine how to write formulas or code without knowing where the data resides on the worksheets and which worksheets contain which type of data.