Contents of cell copied to another sheet in case combo box value is choosen

A

AA Arens

I have a value range in a row (worksheet 1).
That range is listed via Data > Name and Validation on another
worksheet (2)

How to have the name of cell A1 of Worksheet 2 mentioned in Worksheet 1
if the particular value is choosen?

So:

Worksheet 1:

10
20
30 X
40

Worksheet 2 (cell A1 = "Table"):

I choose via combo box value 30.
Neigboring cell X changed into "Table".

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

Shorten the list if a value is already choosen before 3
Value copied based on choosen value from combo box 3
Auto value filled in after dropdown menu value choice 0
Macro to Clear Cell Contents based on Cell Value in another Sheet 4
Forms Control or ActiveX combo box 2
validation list or combo box dependant on cell value 4
Is there a way to parse multiple values in a cell and applycalculations on those values ? 0
Cell reference being changed to a specific criteria in IF formula...HELP! 0

Top