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

[rmartori]

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.

Name	Company	C++	SQL
John doe	Mcdonalds	Yes	Yes
John Doe	Burger king	Yes	No
John Doe	Taco Bell	No	No
Jane Smith	KFC	Yes	Yes
Jane Smith	Culvers	No	Yes
Jane smith	Chickfila	No	No

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.

[Qiu]

@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.

[rmartori]

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.

Date	name	C++	SQL
02-14-2021	bob	Yes	Yes
02-14-2021	bob	Yes	No
02-14-2021	joe	No	Yes
02-14-2021	joe	No	No
03-14-2021	bob	Yes	Yes
03-14-2021	bob	Yes	No
03-14-2021	joe	Yes	Yes
03-14-2021	joe	Yes	No