Clean text file automatically to insert data into excel
$30-250 USD
Оплачується при отриманні
My current software can export reports in a csv file. But the csv file has headers. the number of lines in the header can vary.
I need a method or software so excel can take this csv file and generate a table without these headers automatically.
I will have an exce file, And what I want is that when I open the excel file it will refresh from the csv file, which has the headers in it, and only inserts the information I will use.
Preferably these headers can also be copied automatically to another place so that I know that the report that has been updated is the right one.
I would prefer this to be a visual basic thing.
ID Проекту: #7659317
Про проект
Доручено:
This can be done using a VBA program which will check every row at the top and delete the first few until the data appears. Do you want it to do a lot of excel files at once or just one at a time?
12 фрілансерів(-и) готові виконати цю роботу у середньому за $83
Hello! I'm an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
I have knowledge of Microsoft Excel and VBA. I will be able to automatically pull data from the CSV file and update your excel file. PM for more discussions.