Hello all,
Hopefully this is just a quick one for someone with a working knowledge of VBA coding.
I am looking to modify the Advanced Filter VBA code so that rather than the actual cell contents being copied, instead the cell reference is copied over, thus allowing a modification to be made to to the original data which is then subsequently automatically updated in the advanced filter copied cells.
Range("A1:E5").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _
"G1:G2"), CopyToRange:=Range("J1:L1"), Unique:=False
Hopefully the above makes sense and it is an easy modification?
Also a brief explanation as to how to change VBA code to cell references rather than actual copying of cells would be a great too.
Best Regards
Dan
Bookmarks