I have a workbook with sheet 1 the data for clients. I need to lookup the client name and pull through specific data from sheet 1, their website address located in column D and copy that website address to sheet 2 column B. Their website address is a hyperlink and if I use the normal vlookup it doesn't bring through that hyperlink. Its a pain to go through and set the hyperlink again for all the data retrieved using vlookup. I have no experience using VBA thus I am hoping someone could assist with the VBA code to do this.
Thanks in advance.
Thanks in advance.