Færdiggjort

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.

Thanks!

Evner: Excel, Visual Basic, Visual Basic for Apps, Databehandling, Dataindførsel

Se mere: 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

Om arbejdsgiveren:
( 11 bedømmelser ) New Westminster, Canada

Projekt ID: #29023726

Tildelt til:

(8 bedømmelser)
3.5

10 freelancere byder i gennemsnit $27 timen for dette job

(133 bedømmelser)
7.1
writingapp

"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 på 1 dag
(85 bedømmelser)
5.7
Omar0a

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 Flere

$15 USD in 2 dage
(45 bedømmelser)
5.0
Maheshpatel107

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 Flere

$30 USD på 1 dag
(15 bedømmelser)
3.4
denalekskhua

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 in 7 dage
(0 bedømmelser)
1.4
ITvimana

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 på 1 dag
(0 bedømmelser)
0.0
wellswei88

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 in 7 dage
(0 bedømmelser)
0.0
MohdFirdausJamil

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 Flere

$25 USD in 7 dage
(0 bedømmelser)
0.0
sumitjohnson

"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 på 1 dag
(0 bedømmelser)
0.0