Excel Advanced Filter and Hypelinks

[chipawawa]

Used Advanced Filter to create a filter on a separate wksht in same workbook. Within the list range are cells that have hyperlinks. The advanced filter is on Wksht 1, brings all of Row 1, Row 2, etc to wksht. In Title column is the word without a hyperlink attached to it. How do I bring hyperlink onto Wksht 2 along with all of other info.

Macro below: Sub Filterme() Filterme Macro ' ' Sheet10.Range("A1").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=Range("FilterData!Criteria"), CopyToRange:=Range( _ "FilterData!Extract"), Unique:=False–

 

[SkipVought]

Hi,

Advanced filter to another location shows VALUES, not formats or formulas or hyperlinks, just VALUES.

So why filter to another location? Why not filter in place?

 

[chipawawa]

How do I change the code to accomodate this?

 

[SkipVought]

You didn't answer my questions.

 

[chipawawa]

Okay so I changed the code to filter in place and this has allowed me to bring over the hyperlinks. The problem now is with my user form, the filter command button and search result list do not work. Please help. I have attached my file.

 

[SkipVought]

You have gone to a LOT of trouble, blood, sweat and tears, code, a form, controls ad nauseam...

..for what could be easily done using the AutoFilter feature.

EVERYTHING, as far as I can surmise, could be performed on the Data sheet, columns A:C only!

Is there any reason why the AutoFilter would not work for your application? If necessary, you could simply add a Filter CLEAR button.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}