Please see my code for my advanced filter macro. I need to add Column D to the Range of data to be copied but cant seem to do that easily. It might that I am just not very experienced in Excel and I am overlooking something or it might be that I need to do this another way. The filter to new sheet works great with the exception that I need to include the data in Column D on that new sheet.
Thanks in advance for any advice.
Thanks in advance for any advice.
Code:
Sheets("Project Summary - Template").Range("AE16:AJ21").AdvancedFilter Action _
:=xlFilterCopy, CriteriaRange:=Sheets("Project Summary - Template").Range( _
"CU16:CW19"), CopyToRange:=Range("A16"), Unique:=False