Nvm, I messed around a bit with it and figured it out. Thanks again a ton though, this macro is kicking *** on this project.
Hey you helped me out with some recent code to fill a master sheet with info from various other sheets. For N = 2 To SourceWorkSheet.Cells(SourceWorkSheet.Rows.Count, 1).End(xlUp).Row For M = 3 To Cells(Rows.Count, 1).End(xlUp).Row If Cells(M, 1) = SourceWorkSheet.Cells(N, 1) And Cells(M, 2) = Condition Then SourceWorkSheet.Range(SourceWorkSheet.Cells(N, 3), SourceWorkSheet.Cells(N, 12)).Copy Destination:=Cells(M, 4) End If Next M Next N End Sub Anyway I'm doing the same thing but with a slightly different layout now for a different set of data on the same project. I'm assuming I could restructure this macro slightly and make it work for my new task as well. Do you think you could explain the logic to me for what is happening in the portion I posted above? If i can better understand it I'm sure I could restructure this macro for my current task and the future ones I have with this project.