Convert Text file to Excel and Extract Data
$30-250 USD
Paid on delivery
I need to take a group of text files (attached) and convert it to an Excel spreadsheet that i can extract data from. For example, I want to create a graph of Cumulative Cash Flow through the year 2015, or Economic Limit, or Ultimate Recovery for each case attached.
I envision a visual basic macro that parses the text into columns, then a lookup function that extracts the specific cell i need.
I've attached text, pdf, and excel files that show what I'm currently doing by hand. It would helpful if I could automate this process.
Project ID: #1234520
About the project
60 freelancers are bidding on average $110 for this job
In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are include More
Hi, I have gone through your requirement and I am glad that We can accomplish this task, Please give us opportunity to work with you. Please check PM . Thanks, TTS Team
Hi, I am a computer science graduate and have enough stuff in Excel VBA. Please check PM for demo videos.
Hi Excel can read in text files direct. To create worksheets as in pdf is nice for user reference but not absolutely necessary. It is your choice. Please let us have sample of the rest of the graphs for review.
I am an excel and VBA expert and have been providing customized solutions for over ten years.