Creating 12 monthly reports from a single file

New Contributor

I am trying to create 12 monthly reports (January through December) that are propagated from a single source EXCEL sheet that contains all the data for the year. Each report should update when data is entered on the main sheet. How do I do this?

2 Replies
best response confirmed by GRCDickinson (New Contributor)



I think you may try "Power Query" for the files. 

Thank you for the help. I was able to build the spread sheet as desired. Have a Great day!



@Man Fai Chan