"&J3&" - This is the continent wherein the account 'resides'
%5C - This is the URL code for a backslash (\)
&LEFT(L3,(FIND("@",L3,1)-1) - This code looks for the contents of L3 (email address) and takes everything before the '@' symbol (essentially the username) and attaches that to the formed URL
So, if the person's email is Bob.Joe@company1.com and they're in North America, the link will be:
The reason why I have to do this is that the account names vary quite a lot between various elements of the company. Some use the simple firstname.lastname approach, while others do lastname.firstname, firstname-middleinitial.lastname, etc. There are far too many variables.
The links themselves are working and when you click on them they open a InternetExplorer window and take you straight to the desired page.
This sort of streamlines the process, wherein the user opens each and every person's link, looks up the relevant information, and then pastes it in.
After hours of looking around, I've pieced this code together (based on this code here: http://stackoverflow.com/questions/2...website-data):
This code works if I use a manual address (currently commented out) and does return the right information in the cell I desire (H2), but I can't see to loop it through the list of links and put the corresponding information into the appropriate row.
J3 -> H3
J4 -> H4
J5 -> H5