Hi,

I've been racking my brain and can't figure out a solution to what I want to do!

So I have a worksheet that has results put into it from a database query. This includes the ID of the record. Essentially I want the ID to be a hyperlink or something clickable to the user that will then fire a macro function taking the ID to populate another worksheet with data. I can't figure out how to dynamically create the link which will then fire the UDF. Any ideas?

Hope this makes sense?

Thanks
Gareth