Hello Mr Excel geniuses!
I need some help figuring out something that is probably pretty simple.
I have a workbook with a sheet for each of 9 subs that has monthly hours for two locations, a sheet that lists all subs and sums their monthly hours together, and a master that shows each subs monthly and YTD info, but is formatted and gets PDF'd and sent out.
What I am trying to do is add a drop down to the master so that you can select the month and each subs monthly and YTD totals will be displayed.
So, when August is selected, the table in the Master sheet shows the August and YTD info for each sub.
Any help you can give is greatly appreciated! Thank you again!
I need some help figuring out something that is probably pretty simple.
I have a workbook with a sheet for each of 9 subs that has monthly hours for two locations, a sheet that lists all subs and sums their monthly hours together, and a master that shows each subs monthly and YTD info, but is formatted and gets PDF'd and sent out.
What I am trying to do is add a drop down to the master so that you can select the month and each subs monthly and YTD totals will be displayed.
So, when August is selected, the table in the Master sheet shows the August and YTD info for each sub.
Any help you can give is greatly appreciated! Thank you again!
