Find Jobs
Hire Freelancers

Do some Excel Work

$30-250 USD

Completed
Posted over 9 years ago

$30-250 USD

Paid on delivery
In VBA: Search a directory of text files (1000's) Each text file has 3 fixed length intergers I wish to extract and 1 fixed length interger i wish to ignore, always the same value in all files. 1. Are always 9 integers (about 5 per file) 2. Is always 5 integers 3. Is always the date. 4. Ignore a fixed, always same value 5 digit number. Write above 1-3 in seperate excel (A,B,C, etc) columns with 9 digit integers taking multiple rows. Repeat for all files in directory.
Project ID: 6991611

About the project

33 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I m good at excel and macros... I am ready to star the work... Looking for your project. I will meet your requirement..
$45 USD in 1 day
5.0 (1015 reviews)
8.2
8.2
33 freelancers are bidding on average $93 USD for this job
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$80 USD in 8 days
4.9 (336 reviews)
7.9
7.9
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards
$122 USD in 3 days
5.0 (305 reviews)
7.3
7.3
User Avatar
Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi
$250 USD in 5 days
5.0 (222 reviews)
7.5
7.5
User Avatar
Hi, I'll be happy to help you with this project. I take pride in accuracy, timely completion and support within reasonable time after completion. Please feel free to message me if you need to discuss any questions
$75 USD in 1 day
4.8 (257 reviews)
7.7
7.7
User Avatar
Hello I can help you with your project. Can you give me example of your text files? Do you need VBA code or you need only result? If you do not need VBA code I'd like to use python to do your project. I have an experience of data processing from various formats. Waiting for your response.
$55 USD in 1 day
5.0 (168 reviews)
7.0
7.0
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. We can discuss the budget post discussing the complete requirements. Lets discuss more online on chat. Thanks, Abhinav
$49 USD in 0 day
4.9 (168 reviews)
6.5
6.5
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 220 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$100 USD in 3 days
4.9 (175 reviews)
6.5
6.5
User Avatar
Hello, I can get you this task done in the next 6 to 12 hours. Let me know if you are interested. Thanks
$50 USD in 0 day
5.0 (117 reviews)
6.2
6.2
User Avatar
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this regard. with thanks and regards
$98 USD in 4 days
4.6 (102 reviews)
6.3
6.3
User Avatar
Hi, I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on designing, implementing and analyzing ACBC (conjoint) surveys, pricing models, income statements, business analysis etc. Prior that I have completed MBA and bachelors in Engineering. I have worked extensively on excel and VBA in my job and here on freelancer as well. I believe I can help in your work. Please have a look at reviews provided by previous employers. Please contact for further discussion. Regards! Vikas
$155 USD in 3 days
4.9 (39 reviews)
5.7
5.7
User Avatar
I have over 9 years of experience in Excel and Access VBA. I have developed several Tools, Automation, Dashboard, Database CRM and Online Tools using VBA I have done a similar project using Excel VBA
$83 USD in 3 days
4.9 (12 reviews)
3.9
3.9
User Avatar
Hi, Access/excel expert having 8+ years of IT experience and doing freelancing. I have gone through your requirement and can implement it for you. I will design one access (vba) tool. On click of a button it will search the text files in selected directory and read the data from the files and put into the access table. From the table as per your 3 requirement it will pick the numbers and display in 3 seperate excel sheets. Please send me a sample of your text file. I can show you a sample demo of the tool. Hello, please send me a sample of your text file so that i can show you a demo of the output.
$155 USD in 3 days
5.0 (8 reviews)
3.9
3.9
User Avatar
dear sir I saw your project description carefully and I found myself fully confident about the project and I think I can accomplish the job within time. I have 2 year experience in vba excel. vb.net and c#.net and I have already worked in similar kind of projects in freelancer. some of my sample work is there in my portfolio. I hope you will consider my bid seriously and give me a opportunity to work with you. thanking you swapanchowhan
$35 USD in 3 days
4.5 (4 reviews)
1.9
1.9
User Avatar
The way you described it means your excel file will have (number of files * 3) columns with some of these columns taking multiple rows, just making sure if I understand you correctly. Even if you meant it in another way I could still write up a VBA that takes care of the process.
$50 USD in 1 day
5.0 (2 reviews)
1.6
1.6
User Avatar
Dear Sir,i hope that i will work with you. i promise that i can give our requirements. please give project details with rate for deal. wish that are arranged better quality work for You. I can do your project with 100% satisfaction guarantee.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$188 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
After carefully reviewing the experience requirements of the job description, I have excellent experience in data entry; Ms excel. I also enjoy typing and researching websites. I am available at any time during the week.
$90 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Thanks for posting you jobs. I hope you are doing well. I read your project description. I want to work with you. I am new in freelancer so i am bidding ate lower price. Please contact me for more discussion about project. Thanks Jignesh G.
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Newark, United States
5.0
1
Payment method verified
Member since Jan 18, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.