Hello.
I have to copy the column starting from row 3, which has the first value "invoice identifier" in the second file, where the second row has the value = invoice identifier.
The number of rows is different each time
Windows("template DHL-Duta Iulian .xlsx").Activate
Windows("Anexa Factura emisa in iulie CONSUM IUNIE.csv").Activate
cells.Find(What:="invoice identifier", After:=ActiveCell, LookIn:= _
xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Activate
ActiveCell.Offset(2, 0).Select
Range(ActiveCell, ActiveCell.End(xlDown)).Select
Selection.Copy
Windows("template DHL-Duta Iulian .xlsx").Activate
ActiveSheet.Paste
I have to copy the column starting from row 3, which has the first value "invoice identifier" in the second file, where the second row has the value = invoice identifier.
The number of rows is different each time
Windows("template DHL-Duta Iulian .xlsx").Activate
Windows("Anexa Factura emisa in iulie CONSUM IUNIE.csv").Activate
cells.Find(What:="invoice identifier", After:=ActiveCell, LookIn:= _
xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Activate
ActiveCell.Offset(2, 0).Select
Range(ActiveCell, ActiveCell.End(xlDown)).Select
Selection.Copy
Windows("template DHL-Duta Iulian .xlsx").Activate
ActiveSheet.Paste