Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup list from different worksheet & auto-populate multiple cell
I want to create data on Worksheet 2 (WS2) - example:
COLUMN A COLUMN B COLUMN C Item 1 Price 1 Size1 Item 2 Price 2 Size 2 On Worksheet 1 (WS1), I want to create a drop-down list from Column A on WB2 and auto-populate data from WS2 Column B and C in selected cells in WB1 (example): COLUMN 1 COLUMN 2 COLUMN 3 Use drop-down list from WS2 Column A =Price 1 =Size 1 Hope this is clear enough - any help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to auto-populate a list. | Excel Discussion (Misc queries) | |||
Auto Lookup and Populate | Excel Worksheet Functions | |||
Formatting a cell to utilize list and auto populate | Excel Worksheet Functions | |||
How to Auto-populate cell based on selection of a list item | Excel Discussion (Misc queries) | |||
auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) |