Need help trying to figure out how to create a continuous monthly report

Question

Basically every month someone will download a report. There are a lot of columns but the important columns are a Name Column which will have employee names(often duplicates) and then column H and I which are whether or not they used a program sadly I dont have the documents in front of me this was given to me to do like a half hour before I let work for the weekend. so not at my work computer.

NameCompanyC++SQLJohn doe

McdonaldsYesYesJohn DoeBurger kingYesNoJohn DoeTaco BellNoNoJane SmithKFCYesYesJane SmithCulversNoYesJane smithChickfilaNoNo

What they want is to take this reports  and give a summary file that will be added to and updated monthly. that looks somewhat like the screenshot below.

So february will go under feb, March under March and so on keeping a running tab of how many Yes answers on in the report. It has to be easy for them to do each month by themselves without me and still save the previous months info.

rmartori · Answer

Odd question but if I renamed the data files after their date(or the sheet name after the date.

Say first file 02-14-2021 and the second file 03-14-2021

In this case I would just need to essentiall remove specific columns from a bigger file Technically the name is at Column B and the yes answers are in column H and I

Edit I finally got into work where I could rereview the file, there is a date column called Report date and it is basically in 02-14-2021 format.

DatenameC++SQL02-14-2021bobYesYes02-14-2021bobYesNo02-14-2021joeNoYes02-14-2021joeNoNo03-14-2021bobYesYes03-14-2021bobYesNo03-14-2021joeYesYes03-14-2021joeYesNo

Qiu · Answer

@rmartori

I dont how to add one by one, but I think we can save the last data and append to the current data, then use the Preserving formatting option to output.

Hope this will work for you.

0322-rmartori.yxzp

LatestData.yxdb