VBA Paste below row with Dates Criteria

Closed

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

Hopefully someone can help me. I've Googled this 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()

VBA Paste below row with Dates Criteria
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
Number to words in excel without vba - Guide
How to enable vba in excel - Guide
Vba case like - Guide

Subscribe To Our Newsletter!