Auto value filled in after dropdown menu value choice

A

AA Arens

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looking formula that SUM values with specific value in neighboring colum 2
Looking for the value that indicates last row number that has filled cells 5
Auto populate value from one task to another in MS PROJECT 0
Value copied based on choosen value from combo box 3
Find the correct sheet then find a value on that sheet 8
Possible? Variable X and Y data sources and Auto Charting 0
excel dropdown menu question 2
how to update a record from combo-box in user form? 0

Top