VBA Excel code for importing and formatting data
$10-30 USD
Paid on delivery
I have a .txt that needs to be imported to a .xlsm file and parsed into a column format.
I am attaching 2 files:
- The .txt that contains the raw data
- A .xlsx used as an example of the structure that needs to be followed
There are 3 tabs, the first one with a button that will execute the code, the second one is where the data is going to be imported and formatted, the third one contains an example of the end product. Instructions were added in the excel file.
The deliverable needs to be ready in 2 hrs after winning the project. All the code needs to be properly formatted and ideally commented (in English or Spanish).
Please include in your bid the steps that were added in the excel file as reference and start your bid with "Howdy!" to know that you read the requirements.
If you have any questions please let me know.
Thanks!
Project ID: #29023726
About the project
Awarded to:
10 freelancers are bidding on average $27 for this job
"Howdy!". Hi. I have written many automation Excel VBA macros for parsing files including TXT. Can parse any TXT templates. Ready to write your project. Will complete within 1 hour
Howdy! Hello, I have read, checked attached files and understand your requirements. I can write code to Import txt file to SB sheet. then format data to SB-5 sheet as shown in SB-5. finally message will show no of rec More
Dear Hiring Manager, Greetings from Denys ,hope your day is going well and all is good with you. We would like to discuss the project in details before confirming the bid, so kindly let me know when you are available.
Dear Sir, I read your requirement. I have more than 10 years experience of work as a IT Specialist and developer Thank You Isuru Rupasinghe
I can finish this project in 5 days not in 2 hours. It would be using regular expression to fulfill the function which means it is not as easy as you think.
I do part-time report writing, word processing, excel spreadsheet, PowerPoint slides, and graphic designing (using Adobe Illustrator). I am sure that this project will be completed with exceptional standard, given the More
"Howdy" Read and understood the project can deliver in 2 hours. I have the best experience in working with excel. Will provide you the best wiality work Regards Sumit johnson