Hi!

I want to populate the values of column 'Manufacturing Locations' in a combo box in sheet 1. These locations are stored in a single column in sheet 2. How to do this?

Please help.

Click combobox in the 'Forms' toolbar and draw on the sheet.
Ctrl key + doubleclick to set range used and Cell Link etc.
The cell link shows the item number selected.
Use another cell with the INDEX() function to show the actual item.
Right click & Assign Macro if required.


-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.