Modify macro to copy to next available row
Hi...ihave played around and created a macro that with the use of autofilter
copies my data from sheet 1 to sheet 2 then i filter out the data i don't need on sheet 1 ..works great Unfortunately when it copies it dosen't copy to the next available row in sheet 2..it goes anywhere.Cna someone look at this macro and show me the way to have te data that is filtered copied to the next available row in sheet 2 thanks Sheets("Filled Orders").Select Sheets(" Orders").Range("B6:I25000").AdvancedFilter Action:=xlFilterCopy _ , CriteriaRange:=Sheets(" Orders").Range("B6:I25000"), CopyToRange:= _ Range("B6:I25000"), Unique:=False Sheets("Orders").Select Range("B6:I52").Select Selection.AutoFilter Selection.AutoFilter Field:=8, Criteria1:="<" Selection.AutoFilter Field:=8, Criteria1:="=" |
All times are GMT +1. The time now is 05:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com