asked on
Filter and Copy question
Hi Guys, I have a text file that I open every day and filter in the 3rd row on the Differences column for anything bigger than 0 and then copy and paste it. I am currently using Current Region, instead of EndXl(Down) as the file usually has no differences, but I do not wish to copy and paste rows 1 and 2. My code is this:
Workbooks.Open Filename:= _
"V:\Treasury Finance Controls\Ledger v SS Recs\Recs - Murex_GBO\2013 Recs\11_2013 Recs\BS\Full Ledger\" & Prevday & "\" & "CreditBSRec_Daily_" & Prevday & ".xlsx"
Rows("3:3").Select
Application.CutCopyMode = False
Selection.Copy
ActiveSheet.Range("$A$3:$R
Operator:=xlOr, Criteria2:="<=-1"
Range("A4:r4").CurrentRegi
Is there a way I can just copy the 3rd row if there are no differences. I enclose the file,
CreditBSRec-Daily-20131106-05355.txt
Workbooks.Open Filename:= _
"V:\Treasury Finance Controls\Ledger v SS Recs\Recs - Murex_GBO\2013 Recs\11_2013 Recs\BS\Full Ledger\" & Prevday & "\" & "CreditBSRec_Daily_" & Prevday & ".xlsx"
Rows("3:3").Select
Application.CutCopyMode = False
Selection.Copy
ActiveSheet.Range("$A$3:$R
Operator:=xlOr, Criteria2:="<=-1"
Range("A4:r4").CurrentRegi
Is there a way I can just copy the 3rd row if there are no differences. I enclose the file,
CreditBSRec-Daily-20131106-05355.txt
Microsoft Excel
Last Comment
Michael
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.