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

Ebiru2387

New Member
Joined
Sep 2, 2020
Messages
3
Office Version
  1. 2016
Platform
  1. Windows
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 CountryUSA
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 CountryCanada
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
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

JLGWhiz

Well-known Member
Joined
Feb 7, 2012
Messages
12,979
Office Version
  1. 2013
Platform
  1. Windows
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. o_O
 

Watch MrExcel Video

Forum statistics

Threads
1,127,521
Messages
5,625,296
Members
416,087
Latest member
drth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top