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).
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.