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