Hi there,

Pretty new to macros - and brand new to the Worksheet_Change event (which is what I think I need help with).

Here's what I want to do...
  • I have three worksheets - Sheet1, Sheet2, and Sheet3.
  • In cell C1 of each of these sheets, I have a drop down list box (i.e. data validation) which can say "Project", "Phase 1", or "Phase 2".
  • If a user changes cell C1 on any of these worksheets, I want cell C1 in the OTHER worksheets to change to the same value.


Does anyone have code to do this? Thanks for the help!

~ JF