Hello All,
I am trying to set up a spreadsheet (attached is a dummy version) where in the 'YTD' worksheet I can have a drop down list of months to choose from (January-December).
When a month is selected, I want it to pull the data from that month and all other months before it to show a year to date total (e.g. If March is selected on the 'YTD' worksheet then it will show A,B,C,D columns from January, February and March and show a total of all as well.
I know how to set it up to show the information based on the month selected but I am unsure as to how to set it up pulling more that one lot of information through based on the selected month.
Can someone please help me?
I am assuming I may have to have a 'Master Sheet' worksheet that shows all relevant information so it can pull it all from there which can be hidden later, I just cannot get my head around it.
I appreciate all of your assistance!
Bookmarks