Auto value filled in after dropdown menu value choice

AA Arens

Guest

Posts: n/a

18th Nov 2006

I do have two worksheets.

On the second I choose somewhere a value from a range coming from the
1st worksheet (via the combo box).

How to have it performed that after I choose the value, a string will
be filled in in the neighboring column from the 1st WS.

Like:

1st WS
10
20
30 X
40

2nd WS
If I choose "30" from dropdown menu, "Name" will be placed in location
X

Bart
Excel 2003

« How to pull values from Excel to MS Access? | Displaying Totals on another worksheet »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
populating a dropdown based on choice from a previous dropdown	Conor	Microsoft Excel Programming	2	9th Mar 2006 07:15 PM
auto dropdown menu	damorrison	Microsoft Excel Programming	1	29th Jan 2006 03:19 PM
Dropdown Menu Auto Insert Option	=?Utf-8?B?Um9va2ll?=	Microsoft Outlook Form Programming	1	28th Sep 2005 01:37 PM
Can I have auto dropdown when cursor is over a main menu item?	Jack Jack	Windows XP Customization	1	16th Aug 2005 11:06 AM
Dropdown menu auto recognition?	Patty via OfficeKB.com	Microsoft Excel Misc	4	9th Aug 2005 05:30 PM