VBA Excel code for importing and formatting data

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.


Навыки: Excel, Visual Basic, Visual Basic для приложений, Обработка данных, Ввод данных

Показать больше: vba excel code install add ins, vba excel code extractor page web, vba excel fill rows form data, vba excel web query salarycom data, vba excel code search bar, vba excel code optimize, ftp vba excel code, vba excel word preserv formatting, sample vba excel code scrapes stocks, vba excel sumup specific cells data, vba excel code 2010, ftp vba excel code upload text file, vba excel ten pin bowling data entry, treemap vba excel code, tic tac toe vba excel code, how to make a calculator in vba excel code, excel macro for formatting data

О работодателе:
( 11 отзыв(-а, -ов) ) New Westminster, Canada

ID проекта: #29023726


(8 отзывов(-а))

10 фрилансеров(-а) готовы выполнить эту работу в среднем за $27

(133 отзывов(-а))

"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

$25 USD за 1 день
(85 отзывов(-а))

Hello, the attached documents looks interesting to me, I can easily handle your job I have been working on Data Entry, Data Scraping, Internet Research for more than 6 years with experience in Microsoft Word, Excel, Go Больше

$15 USD за 2 дней(-я)
(45 отзывов(-а))

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 Больше

$30 USD за 1 день
(15 отзывов(-а))

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.

$20 USD за 7 дней(-я)
(0 отзывов(-а))

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

$30 USD за 1 день
(0 отзывов(-а))

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.

$30 USD за 7 дней(-я)
(0 отзывов(-а))

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 Больше

$25 USD за 7 дней(-я)
(0 отзывов(-а))

"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

$20 USD за 1 день
(0 отзывов(-а))