Forum Discussion

GRCDickinson's avatar
GRCDickinson
Copper Contributor
Feb 17, 2021
Solved

Creating 12 monthly reports from a single file

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 i...
excel
Man Fai Chan's avatar
Man Fai Chan
Iron Contributor
Feb 17, 2021

GRCDickinson 

 

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

  • GRCDickinson's avatar
    GRCDickinson
    Copper Contributor
    Feb 23, 2021

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

     

    Michael

    Man Fai Chan