I need some help with improving my VB code. I have a few issues that need ironing out!

Hi everyone,

I am a complete novice when it comes to Macros and VB but I thought it might help with with formating my spreadsheet. My knowledge has gotten me as far as being able to record individual macros (Module1) and then stringing them together to activate one after the other (module2) using the Call function.

I have been searching these forums (and others) for specific pieces of coding that I think will do certain tasks. It seems to do what I want it to do however, there are still some actions that I do not know what to do.

I have attached two example spreadsheets: Contacts_EG1 contains the unedited data
Contacts_EG2 shows my intended end result


I also attach the coding Module2.txt Module1.txt I have created thus far. I would appreciate some help with completing a few last actions and making it a little more efficient (if possible?). I've done as much as I can possibly do on my own, some expert help will be fantastic!


NOTES:
There seems to be a problem with Macro6 (Cell.Offset)?? and Macro10. You may be able to see at this point that some Email addresses and Phone numbers are not quite in line with data showing across the rest of the row. Is there a way of ensuring data is kept inline?

Thanks again for your help. Contacts_EG2.csv.xlsx Contacts_EG1.csv.xlsx
Tom