Hi All,
First time using this forum so welcome all.
Just a question with my "Excel Advanced Filter - Macro" as below. Everything works fine
Issue: is the Range and that it changes "A4" will always be the first cell, however it may go from "A4:A6" or "A4:A333". Therefore, I need the Macro to take the last field etc.
MultipleSKU Macro
'
Sheets("EMEA - 12mth DEMD").Cells.AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range("A4:A12"), CopyToRange:=Range("F2:U2"), Unique:= _
False
End Sub
Thanks if anyone can help
First time using this forum so welcome all.
Just a question with my "Excel Advanced Filter - Macro" as below. Everything works fine
Issue: is the Range and that it changes "A4" will always be the first cell, however it may go from "A4:A6" or "A4:A333". Therefore, I need the Macro to take the last field etc.
MultipleSKU Macro
'
Sheets("EMEA - 12mth DEMD").Cells.AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range("A4:A12"), CopyToRange:=Range("F2:U2"), Unique:= _
False
End Sub
Thanks if anyone can help