Advanced Filter Removes Hyperlink

**stevedes7** · 10-17-2009, 10:04 PM

I've used Advanced Filter to create a filter on a separate worksheet in the same workbook.

Within the list range are cells that create a link to Google. For example, if A1=Soccer, then F1=Google Search (http://www.google.com/search?q=soccer). This is located on Worksheet 1.

The advanced filter is on Worksheet 2, and brings all of Row 1, Row 2, etc to the worksheet. However, all that shows up in the Google column is the word "Google" without a hyperlink attached to it.

How do I bring this hyperlink onto Worksheet 2 along with all of the other info.

Thanks guys.

**vzq** · 06-10-2010, 05:08 AM

I'm experiencing the exact same problem and haven't found any solution. I have an Excel database, where some rows contain a hyperlink to a .doc file. I'm filtering specific rows to a new worksheet, but the hyperlinks don't work. They show up as blue and underlined as if they would work but they're only text.

Any suggestions? Is there another way to filter the database so that the hyperlinks would work? I've tried to query the database to a new workbook to no avail.

I hope somebody could help. Thanks!

**venol** · 10-15-2011, 11:35 PM

Yes, I have same problem.. But, little different. My problem is Advance filter not display the result if I add one worksheet(Main Menu) contain hyperlink to link to another worksheet.

What's problem ?
Thanks for your help..

**NBVC** · 10-15-2011, 11:51 PM

stevedes7,

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this

**NBVC** · 10-15-2011, 11:52 PM

venol,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.