Automation in Excel - open to bidding
$30-250 USD
Pagado a la entrega
I need an experienced Excel Programmer to develop an automation/vb script to do the following.
1. Import a txt file from a specified location (with the most recent timestamp) - which is in a format as listed below - YYMMDDXXXXX,TXT
2. Delete contents of last 2 Columns except last row (the number of rows may change from file to file)
3. Change Column C format to a Custom format of 16 zeros
4. Save file in format Company_Name (which will not change) - MM-DD-YYYY (2 days prior to date found in txt file) and save as Excel 97/2003 format.
Nº del proyecto: #5066148
Sobre el proyecto
37 freelancers están ofertando un promedio de $84 por este trabajo
Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among n Más
I'd be happy to write the macro for that, and can start as soon as you are ready ---------------------------------------------------------------------------------------------------------------------
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
Hello; your 5-star excel and vba coding expert is ready to help your macro project. I had many similar tasks, all achieved with 5/5 rating, pls check my profile and feedbacks....ready to go ahead, upon your confirmatio Más
Hi, Let me help you with this. Could you send me a sample file of source file and output file? I can work on this and send you the result in a day. Looking forward for your quick reply. Regards, Susanto
Its hardly two hours work for experienced Excel developer...I have great experience in excel coding and complete this script within 2 hours....Lets start
I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the u Más
VBA Excel expert with 100% Repeat Hire Rate I can make this very fast. Please check my reviews and portfolio as proof of my expertise.
Ready to work on this.. please assign to me. will deliver project with in time. looking forward to work with you
I have built numerous excel macros for my current company. (Over 50) And I have done much more complicated and difficult functions in Excel. Your best excel tool will not only work functionally, but will be easy to use Más
Hello, I can deliver the VB script with good quality and without any bugs. Best Regards, Saravanan
Completed.. Hi every thing is complete other than the 3rd point mentioned. It is unclear for me. Rest of the things are done including the name of the file to be saved with. Let me know if you can award me this pro Más
Expert on excel program is my added advantage and able to do the excel database program very well. Familiar with data entry and be able to source data from internet google yanoo etc...familiar with internet market mark Más
I am good at MS Excel and an expert with Excel Macros and VBA. I have developed many apps etc similar to the job required