Good morning everyone, I am looking for some help with quite a specific problem I have if possible please.
I have a workbook to track my teams productivity in 8 areas. I have created a tab for each individual within the workbook which I populate with their numbers each month.
What I would like to do, is create an additional tab in that workbook with two drop-downs. One for name and one for month, so that when I select their name from drop-down one, and the month from drop-down two, it will auto-fill their numbers from their individual sheet into the new tab so it can be printed.
Is there a way to do this?
Many thanks in advance
Bookmarks