Excel Macro that merges duplicates and adds two calculations

That's so easy, thanks Marvin! I have some follow up questions on this, should I create a new thread or post in here?

That's great, I really like how you also commented and listed in the file exactly what you had done.

I was able to follow your instructions to do it from scratch as well myself (well I had to google DNR's and how to use them and now it makes sense, then I couldn't figure out how to refresh PT's, which I learned how to do as well as the macro you used to refresh it ActiveWorkbook.RefreshAll) great stuff!

What I need to do is show only unscheduled meetings, and hide the meetings that are fully scheduled and keep a daily tally on meetings scheduled. Once a certain amount of meetings are scheduled, they are removed from the data.

Maybe I should create another thread for my second part of the question? So every day, for each entry I need to say "this many meetings scheduled on this day" and then I need a totals for the value and totals overall for day and grand total. I figured I could just include that in the original data and have the PT load it up for me. I'm obviously doing something wrong, the total should be grand total should be 33 in my example, but it's all messed up. I guess it must be the data range I selected, shouldn't include totals? Do I even need a totals in my original data or can I just the PT to create it for me?

The other part I'm having a lot of trouble with is that since the data changes daily, how do I merge it with the existing tally? So let's say I get a new report, it has the new data for meeting name and days unscheduled. I can copy/paste that data as is into the DNR, but then it doesn't match with the daily tally. So for example let's say the new data only has 4 values, the previous meetings have been scheduled. I included it in tab "Data Day 2". Some of the values are the same, except the days unscheduled goes up by 1. But then some are gone, and some are new. I want my tally to continue, but the new data needs to be included. I could manually see all the new values that match, and then add them in manually, without deleting my old values, but that would take forever.

What I was thinking is, would there be a way to hide the values that aren't in the new data somehow, and only show the new data which is meetings unscheduled. This seems too complicated to me, I'm confusing myself.

Hey Marvin, sorry I don't think sorry that this is what I had wanted, or maybe I don't understand it correctly.
I apologize I wasn't clear in my explanation, you expended effort to solve my issue, I really appreciate it. It seems like we are very close, but I don't know how to change the way you created the PT to the original PT.

I like the original Pivot Table, it accomplished half of what I need. The grand totals part is good, I need to add that to the calculation. The rest is I need to keep a continuous tally of meetings scheduled, I don't need to worry about the room or groups.

Let me try to explain a little better:, I want to track the # of meetings scheduled per day and keep the record of it.

So I need the name of the meeting, the average # of days unscheduled and the count of meetings with the same name. The same meeting names won't show up in the summary twice, so the PT accomplished that perfectly and the average and count as well. That part is essential, but then after that, I need to also track a daily tally as well, which I guess would build over time.

So let's say day 1 had data like:

Meeting 1 unscheduled 20 days
Meeting 2 unscheduled 9 days

And then we scheduled one of the two meetings on Feb 28. The data should reflect on what day the meeting was scheduled.

Now on day 2 we have, two new instances of "meeting 3"

Meeting 2 unscheduled 10 days
Meeting 3 unscheduled 1 days
Meeting 3 unscheduled 1 days

So now we have meeting 1 which is already scheduled and should have a tally of 1 on Feb 28. And then I have to include these new data into the PT which I will copy/paste from the data sent to me.

On day 3, the data changes because Meeting 2 was scheduled and can be removed from the list of ongoing unscheduled meetings, but should remain in the tally of being scheduled on Feb 29. The grand total would be 2 meetings scheduled.

Meeting 3 unscheduled 2 days
Meeting 3 unscheduled 2 days
Meeting 4 unscheduled 1 days

When it's a small data set, I could easily add/remove them, but I'm worried with 50+ items, it's going to be a bit more difficult to keep track of, but still is doable.

I wanted to add that the new items I get also have a unique identifier as well. I don't know if that makes a difference?