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.

  • Try to provide a simple sample about data source here. – Lee Aug 13 at 8:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.