Excel Programming
$30-250 USD
Paid on delivery
I get several files in excel which have email address in them. I need all the email address consolidated from all the excel file in a single excel file one below the other. The application must have an option to load several excel files together in batches and then extract the email address from each of the excel file into a single excel file. The raw data file structure could be different and may not be same.
Once the email list is loaded into the main master file, if the email address has anything before of after it... it should only take the email address.....example if this is how you see the email address in excel sheet (abcatabcdotcom) tel-- +xxxxx-xxx-xxxx84.0979760050 the final excel sheet must only have
Email address which have more than 20 characters before the "@" sign should be eliminated from the main master file
All duplicates should be eliminated from the main master file
Budget $50
Project ID: #4434792
About the project
51 freelancers are bidding on average $55 for this job
One question only. It's about the raw data files. Do they have the data spread over multiple sheets OR all data is in one sheet? Thx.
I can give u a simple application, which run , you can select folder of files or many files at a time and click on output button. You can get the output excel file.
Hi, Ready to start your work. Eagerly awaiting for your positive reply. Please check your inbox for further details. Thanks, Shaik.
My rating is 5.0... My project completing rate is 100%... My payment and milestone are reasonable...
Would be able to create this quite quickly - PM sent - would love to discuss in more detail
Hello Patodia Ji, I have prepared the macro required by you. Its working perfectly the way you want. Please see your PMB for further details and attachments.