I'd love a bit of code that could help organise this laborious chore that, at the minute, i do manually.
In the attached Sample.xltm worksheet i'd like to automate using some vba code the 'Client Details' area highlighted in orange, specifically the address in A11 and the email address in A13
To get the information for these 2 cells I have to look at the data highlighted in blue.
The email address is within the text in J29 contained within the < > brackets which i'd like extracted and placed in A13
The address has to be found by copying the text that is always below J59 cell and then go toenter it into the search box, hit enter and extract the full address results and paste into A11.HTML Code:
If this is feasible it would be a great time saver that i could add to other macros that i plan to use.
Regards
John
Bookmarks