Autofilter macro

Hi Everyone,

I have spreadsheet that has two tabs. One the first tab, entitled 'Dashboard', I have the text along the lines of 'Search for a name here'

On the second tab, entitled 'Team List' I have the details of the team, eg name, address, emergency contact etc.

I recorded the following macro:-

Please Login or Register  to view this content.

What I want to do is type in 'Jones' into the search area, the marco to copy and paste that ino the autofilter, and all of the names with 'Jones' be displayed.

The macro above works great for this, but if I enter 'Smith' it still displays the details for 'Jones'.

I think its because of the "Bob Jones", - "David Jones",- "Sally Jones") bit, but I dont know what the generic script for this would be.

Can anyone help?

Thanks
Alex

Hi, Thank you for your help so far, unfortunately the code supplied by Tigeravatar didnt work work, although your help is appreciated. The debugger wouldnt go past the range section but Im not sure why not.

I have attached a VERY basic version of my file. Please dont think that my excel training has been that simple!

Thanks for your help
Alex

Hi Watersev, this is fantastic and also answers my question! Just one thing, can I keep the hyperling associated with the original cell?
thanks

Hi,

Thanks for all your help. Im sorry its taken so long to get back, Ive been away from work for a few days.

The file attached above says that it corrupt when I try to open it. Am I doing something wrong when opening? Ive tried to save it first with the same result.

Would you be able to post the code by any chance?

Thanks again
Alex

checked the attached file, works normally

Please Login or Register  to view this content.

Briliant, thanks Watersev. Ill try it straight away.

Wow! Thats fantastic!

Thank you so much,
Alex