VBA Paste based on Date Criteria

tomwilliams Posts 2 Registration date Thursday March 23, 2017 Status Member Last seen March 24, 2017 - Mar 24, 2017 at 09:36 AM

I would be very grateful for some assistance with this spreadsheet I am attempting to create. I've Googled what I am trying to do several times and couldn't quite get the answer I'm looking for. I have data that I load and sort each day. I tally up the data (units) by department and I want to be able to just copy the units that I have tallied up by department and paste it into another section of my spreadsheet that represents the date that I have set for the data.

I am looking for a macro that will allow me to copy units in cells (C5:C17) and paste (as values) in one of the columns from cells (G5:AK17) if one of the cells above in G4:AK4=C4

G4:AK4=calendar days
C4= today()

Thank you very much in advance for taking the time to assist me with this spreadsheet of mine.