Forum Discussion
PaddyB
Dec 25, 2021Brass Contributor
Import Excel and Sort by eMail-Domain
Hi all merry XMAS to you all I use the time to get some "long term wish" fixed but no luck at all - excel is not my "world" 🙂 my problem ist I get every month a CSV from one of our "Saa...
NowshadAhmed
Dec 26, 2021Iron Contributor
You might need to use a macro to create the worksheet based on unique domain names. And then another macro to copy the relevant data for the domain names. You might need to separate the domain name from the email addresses first. Something like this will help:
RIGHT(A1,LEN(A1)-FIND("@",A1,1))
Once you separate the names, macro can do the rest.
Side note: If I were to do the work, I would not create separate sheets for each domain. I would lump them in one formatted table and filter them to display only those I need to work on.
- PaddyBDec 26, 2021Brass ContributorI will give this a try - but not the Macro 🙂