Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 24
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to auto-populate a list. Labkhand Excel Discussion (Misc queries) 16 October 29th 08 12:35 PM
Auto Lookup and Populate CB Excel Worksheet Functions 0 August 4th 08 04:10 PM
Formatting a cell to utilize list and auto populate Amy Mucke Excel Worksheet Functions 0 March 18th 08 07:43 PM
How to Auto-populate cell based on selection of a list item AK9955 Excel Discussion (Misc queries) 2 April 30th 07 10:04 AM
auto populate cell based on previous cell drop down list selectio. PuzzledbyLists Excel Discussion (Misc queries) 2 September 11th 06 01:28 AM


All times are GMT +1. The time now is 10:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"