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 [login to view URL], rows 20-50 relate to S/N ZZZZ, they need to go to [login to view URL], etc)
there is a new csv file every day with new data [login to view URL]
also the time and date in columns is in EST and needs to be converted into UTC.
the process needs to be fully automated.
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)
Such jobs are my daily practice. I think you overestimated the budget limits for this project, I can do it at a lower price if you repost the project with a lower budget and invite me fot it. I plan to complete the project via writing an Excel macro contained in a separate XLS file.
This approach makes further use of the macro very convenient by offering usual Open file dialog to identify the current input file.
Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees.
Regards!
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
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.
I have over 28 years' as a technical writer, developer, and CIO. I have created complex, Excel apps for large clients like AT&T, Cox Communications and others. I have an extensive finance background and am very skilled with EXCEL. I would like to be of assistance. Let's get started.
Hello
Me an Ms-Excel Expert working on MS-Excel & VBA for the past 10 years. I am ready to do your work and could start right now. I have already done a no. of successful Access Projects and can provide u sample copies if you so desire. U can expect quality work in time.
Thanks