In excel, I am trying to create sheets that grab data from the master sheet based on which drop down is selected in the master sheet.
Example would be I have monthly stats sheets. On those monthly stats I want a drop down for all possible employees based on sheets created about each employee. In that employee sheet, A1 would be "Number of Cases". A2 would be the number that is pulls from January A2 IF January A1 pull down is selected as that employee. So in January A1 would be a pull down which lists employee sheets. If the right employee is selected and you enter 10 into A2 of January it would populate on the employee A2 cell. But if another employee is selected then it wouldn't grab that data.