Conversation Between mrice and cowboy713

2 Visitor Messages

  1. Nvm, I messed around a bit with it and figured it out. Thanks again a ton though, this macro is kicking *** on this project.
  2. 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.
Showing Visitor Messages 1 to 2 of 2

Search Engine Friendly URLs by vBSEO 3.2.0