Sort and Filter List 1 to remove all data entries of employees with an email address ending in @[login to view URL]
Also remove all entries for those people who have no email address listed (blank email field)
Each person on this new list should only have an email address that does not end in @[login to view URL]
Save this new filtered list file as: Contractors
Add filtered data from List 1 and Consolidate with List 2
List 2 should now have all data entries from filtered List 1 plus existing data entries in List 2
Save this new filtered List as file: Contractors and Employees
Cross Reference List 2 with List 3 and remove all data entries for those people who do not appear in List 2.
List 3 should only contain data entries for the specified entries in List 2 – Remove all other entries
Please Note: the same person may have multiple entries under their names. Please ensure all entries remain on the list. The first name, last name and email address will be the same, however the course name in field H will be different. Must retain records for all the different courses that a single employee has taken.
Save this new filtered list as file: Reports
41 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön
Can you please send me your all excel lists please now? Ready to Organize your excel lists very FAST. Highly Expert and Experienced in EXCEL DATA organizing here.
I am a professional with a decade of experience working in a US based NASDAQ registered company with all the knowledge and skills required for your project. Please send me a message and we can start working.
Hello, I have substantial experience in excel and VBA, and I will be happy to assist you with your data formatting job. Please share your project details over chat. BR, Razvan
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further on chat.