I'm trying to summarize data based on a year in a separate sheet in the same workbook. I want the summary to retrieve data based on months.
So for example, I'll select a year in this new sheet, i.e "Yr1", I want the months corresponding with year 1 to be populated from the original sheet.
The original sheet is in the following format,
Jan-17 to Dec-17. I essentially want these dates to be populated in the 12 columns. If I select Yr2, I want the columns to populate Jan-18 to Dec-18.
Is there a way to do this through match index as ive been trying and it hasn't worked or is there any other way.
Help is greatly appreciated
Bookmarks