Hello excel users.
I am trying to create a more robust copy and paste macro.
Basically, every day I receive 2 - 3 reports with users I have to create, move to other domains and users I have to expire, this reports contain about 50 - 70 columns of info, of which I need 2 - 4. What I am trying to do is create a macro that does basically this:
Search for a column name (for example "name").
Copy and paste the "name" column into a different sheet.
Create a formated table (keep in mind the number of users changes so this has to be dynamical also)
I am providing 2 workbooks as example, the info in red is the one that I need. First is a mookup with what I start and the second is where I want to end up.
Example1.xlsxExample2.xlsx
Thanks for any help.
Bookmarks