Hi,
I am using Advanced filter to filter the data to a different location in the same book using a small macro code.
The primary datasheet has working hyperlinks, although when the advanced filter copies the data to another sheet the text remains formatted but there are no hyperlinks connected to the text.
Can someone help with this please.
My advanced filter macro
I am using Advanced filter to filter the data to a different location in the same book using a small macro code.
The primary datasheet has working hyperlinks, although when the advanced filter copies the data to another sheet the text remains formatted but there are no hyperlinks connected to the text.
Can someone help with this please.
My advanced filter macro
Code:
Sub Drill()
Sheets("owssvr(1)".Range("Table_owssvr_1[#All]").AdvancedFilter Action:= _xlFilterCopy, CriteriaRange:=Sheets("Admin").Range("I2:J3"), CopyToRange:= _Range("E5:AD130"), Unique:=False
Range("E6:AD130").Select
End Sub
Last edited: