Copy values from row to another sheet matched to todays date

[M4crew]

I could use a little help to accomplish what seems to be a simple task, but I can't seem to figure this one out.

The "List" sheet is updated throughout the day by a number of users. From that data, I calculate a few totals and averages into the "Counts" sheet to track certain metrics, etc.

Each morning, I use a macro to run code that re-sorts "List" and removes any completed work. What I would like to do is capture the totals and averages on the

"Counts" sheet and save that information into a row matched to "today's" date on the "Summary" sheet. For simplicity for the users, I'd like to start this new code when the other

code starts (triggered by a key stroke shortcut that everyone is already familiar with). The other critical part is I don't want the "Summary" data to be updated more than once per day.

Any thoughts on how to write this so it checks the row in "Summary" corresponding to today's date and if the row is empty, copy just the values over. But if there is already data there, just end it?

I've learned a lot from this site, but my skill level is ultra-novice, so the simpler the better.

Thanks

"Counts"

Total Pending Avg Hours

5 4 23.4


"Summary"

Date Total Pending AvgHours

10/1/23

10/2/23

10/3/23

 

[Herakles]

I could use a little help to accomplish what seems to be a simple task, but I can't seem to figure this one out.

The "List" sheet is updated throughout the day by a number of users. From that data, I calculate a few totals and averages into the "Counts" sheet to track certain metrics, etc.

Each morning, I use a macro to run code that re-sorts "List" and removes any completed work. What I would like to do is capture the totals and averages on the

"Counts" sheet and save that information into a row matched to "today's" date on the "Summary" sheet. For simplicity for the users, I'd like to start this new code when the other

code starts (triggered by a key stroke shortcut that everyone is already familiar with). The other critical part is I don't want the "Summary" data to be updated more than once per day.

Any thoughts on how to write this so it checks the row in "Summary" corresponding to today's date and if the row is empty, copy just the values over. But if there is already data there, just end it?

I've learned a lot from this site, but my skill level is ultra-novice, so the simpler the better.

Thanks

"Counts"

Total Pending Avg Hours

5 4 23.4


"Summary"

Date Total Pending AvgHours

10/1/23

10/2/23

10/3/23

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.