Auto Change Cell Data

[missymew]

I need to know how to do the following;

When someone clicks on a specific cell, I want a different cell to then fill with data from another worksheet, can this be done?

For example, I have cells on a speadsheet box 1, box 2 and box 3. What I want, is when someone clicks on say box 2 to selects that option, then I want box 4 to auto-fill with the price I have from another spreadsheet,

Hope this helps?

 

[missymew]

Or if its easier to explain, just change one cells colour to white when another specific cell is selected

 

[Smitty]

Welcome to the Board!

Check out this tutorial on VLOOKUP.

You might also want to look at this Hall of Fame post on Dependent Data Validation.

As for your second post, I'd take a look at Conditional Formatting instead of a selection event, which involves VBA code.

HTH