I want to be able to have a pick list with two columns setup in a worksheet and pick from that list in another worksheet to populate two columns.
Pick List Sheet would look like this
A Item 1 Item 2 B Johnson 22 C Jones 45
Destination Sheet would look like this
A Item 1 Item 2 B Drop down to choose Johnson from the pick list, Item 2 is populated with '22'
How could I achieve this?