excel - Data Validation to Update Cell on another Sheet -
i working on roster contains multiple areas of information. there "data" sheet contains of related information , couple sheets parse out info resides on "data" sheet. what trying force data validation dropdown located on 1 of input sheets update cell on "data" sheet when selected. keeps causing excel hang current code. the data validation easy 1-6 if helps. private sub worksheet_change(byval target range) if selection.count = 1 if not intersect(target, range("e6")) nothing dim currentmbr integer currentmbr = sheets("roster").range("b4").value 'b4 contains row number on data sheet selected member sheets("data").range("e" & currentmbr).value = target.value sheets("roster").range("e6").value = "=data!e" & currentmbr end if end if end sub once data sheet updated, want original cell return being reference info on data.