We have a csv file with about 20 columns and 100-150 rows.
the data in the file needs to be split into multiple CSV files automatically, according to rows (e.g. rows 1-20 relate to S/N XXX, they need to go to [url removed, login to view], rows 20-50 relate to S/N ZZZZ, they need to go to [url removed, login to view], etc)
there is a new csv file every day with new data [url removed, login to view]
also the time and date in columns is in EST and needs to be converted into UTC.
the process needs to be fully automated.
51 freelancers are bidding on average $270 for this job
Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)
I have 20 years Excel experience and strong VBA skills, and I have completed hundreds of similar projects over the years, so you can be sure of getting a quality solution and great service.
Hi, I have gone through your requirement and I am glad that We can accomplish this task, Please give us opportunity to work with you. Please check PM . Thanks, TTS Team
Hi, Kindly send your file here. i will do it and send before selecting me also. is not it wonderful offer? so waiting for your reply [url removed, login to view] you. Your satisfaction is my success muthumuni
Can achieve this using VBA for a much lower rate. Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement.