In Progress

Need a TXT, Microsoft Excel and VBA expert guru for a small project

I have four sheets that need to generate data in another sheet, for two sheets we also need to save data as .TXT. Please note that the .txt files that need to be generated have specific instructions on characters, the length, begin and end position.

The data doesn't need to be restructured, but simply a new sheet needs to be generated like using VLOOKUP for just showing the data in another sheet.

1. Convert from .TXT file to Excel sheet > Data in sheet A > Generate sheet B (11 columns only).

2. Data in sheet C > Generate sheet D (28 columns, 15 empty, so 13 only - and convert to .TXT with specific string/character position instruction).

3. Convert two .TXT files to two Excel sheets (E and F) > Generate Sheet G.

4. Data in sheet H & I > Generate sheet H (save as three seperate .TXT-files with specific character position instruction).

Skills: Data Processing, Excel, Visual Basic

See more: file guru, expert in microsoft excel, excel expert 2016, excel 0 to expert, small project macro vba, small project vba excel, excel vba small project, microsoft excel vba project organization, vb6 txt excel, vba import txt excel text type, csv txt excel, vbscript export txt excel, save utf txt excel, excel vba install microsoft excel 110 object library, import txt excel parse, convert txt excel, convert txt excel monarch template, add vba creator microsoft excel, microsoft excel project function, start project microsoft excel

About the Employer:
( 70 reviews ) Metropool, Netherlands

Project ID: #10216597

4 freelancers are bidding on average $26 for this job


Hi, I am good at Excel and vba. Looking forward to work on this project. Plz provide me the text file and excel files to read inline with the description. I can covert data from text to excel.

$34 USD in 1 day
(164 Reviews)
$35 USD in 1 day
(39 Reviews)
$20 USD in 2 days
(5 Reviews)

A proposal has not yet been provided

$15 USD in 3 days
(0 Reviews)