Find Jobs
Hire Freelancers

Excel worksheet data extraction

$30-250 USD

Completed
Posted over 5 years ago

$30-250 USD

Paid on delivery
I have 4-6 separate commission reports that are all either CSV for excel files. They all have multiple columns of information but I only need 7 or so columns from each spreadsheet. Each column is named differently and in different orders between the reports. I need to extract the 7 columns that I need from each report and combine them into one master report. The 4-6 commission reports will be a new file every month. I need the information to stack on top of each other in the master report. For example, if commission report #1 has 3 sales that information will be in lines 2-4. If commission report #2 has 5 sales that information will be in lines 5-9. And so on. I need someone to create a formula or VBR or something else so I can simply choose the 4-6 separate commission reports to use in the formula and click a button. All you Excel experts out there, is this possible?
Project ID: 17762300

About the project

50 proposals
Remote project
Active 6 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
I am proficient with excel macro/VBA development, I can write the macro to perform the data manipulation as specified in your project, if you are interested feel free to message me, I am available to start your project immediately, looking forward to chat further and work on your project
$50 USD in 3 days
5.0 (97 reviews)
6.1
6.1
50 freelancers are bidding on average $123 USD for this job
User Avatar
Dear Employer, Yes its very much possible. I understand most of the things in your job. Please message me. I will do the job for you. Thanks and Regards, Ash
$200 USD in 3 days
5.0 (187 reviews)
7.6
7.6
User Avatar
Hi, if let's say Report1, will have always the same structure (the same column order and names), so I can code a macro where you will select the 4-6 files and the master report will be generated. If even the same report can also change the structure, so we have to find another sophisticated solution which will be more complexe and more expensive. Please let me know more details. Thanks
$50 USD in 2 days
4.9 (296 reviews)
7.7
7.7
User Avatar
Hello! My name is Paris and just had the chance to read your project's brief. I was very excited that you mention Microsoft Excel because this is my favorite field and MS Excel projects are among the tasks I work with regularly and know exactly how to handle them. You mention that you need somebody to automate the process of retrieving data coming from 4-6 separate files and located in different columns. This can be done through VBA code and I can do it for you. You can have the reports in a single folder. the code will detect the correct column and will bring the right data in. I'm going to spend less than 2-3 days to complete your project including required revisions for a total payment of $150. I never ask for any payment in front. I claim the milestone release once the project is completed and my client is happy with the result. I'm a very experienced and skilled MS Office developer as you can easily check for yourself. You're welcome to visit my personal page on this platform and get an idea of who I am and what services I deliver to my clients. I'm looking forward to hearing from you. Sincerely, Paris Pallas
$150 USD in 3 days
4.9 (236 reviews)
7.4
7.4
User Avatar
That is very much possible with the click of a button with the VBA script behind. Hello there, This looks feasible and I can do this quickly. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline and budget. Thanks A
$96 USD in 1 day
4.9 (176 reviews)
6.5
6.5
User Avatar
Hi there, I’ve checked the project details and I can do this perfectly. I have huge experience in working with these projects. Waiting for your quick reply. Look forward to hearing from you soon. Best Regards
$155 USD in 3 days
4.9 (127 reviews)
6.5
6.5
User Avatar
I am ready to start right now.I am a full time dedicated freelancer. Dear Hiring Manager, I have read your job description carefully and I’m very considering your job such as these capabilities. I have fantastic experience in this fields such as Data Entry, MS Excel and other related tasks. I am full time dedicated freelancer. I have 3 years+ experience in these categories. I believe my capabilities would be ideal for you. I can complete this job within the necessary period. You can get hold of me instantly to discuss this position further. I am waiting for your kind respond. I am ready to start right now. Thanks. Best Regards, Masud
$50 USD in 3 days
4.9 (151 reviews)
6.2
6.2
User Avatar
am not a random bidder.. Please ping me if you are interested iwth my proposal and share sample reports.. thank you..
$250 USD in 3 days
4.9 (28 reviews)
5.0
5.0
User Avatar
Hello.....! I read carefully the project description. I got understand it. I'm highly interested. I have properly skill on ## Admin Support ## Real State ## Web/Internet Research ## Address Finding ## Review Writing ## Email find expert ## Linkedin email hunting ## Potential Lead Generation You can hire for my another skill. Other Skills ## Data Entry ## Email Scraping ## Information Collection ## Data Collection ## Web/Data scraping ## Email Extraction ## Web Data extraction ## Image Extraction (can also organize them by renaming and moving to folders) ## MS Excel expert ## Wide range of output format (Excel, CSV, XML, SQLite, SQL Server Compact) So if you have any related work , please contact me
$45 USD in 3 days
4.8 (21 reviews)
4.9
4.9
User Avatar
Hello I saw your project and I understand and I can do this because I have good experience about this and if you give me your project then I will give your good quality work
$70 USD in 3 days
5.0 (18 reviews)
4.4
4.4
User Avatar
Hello Sir, Have a great day ahead I went thru the description and this task can be done Kindly contact me and send your excel csv file I will start it by today I look forward to hearing from you Thanks regards Thushara
$100 USD in 3 days
5.0 (29 reviews)
4.4
4.4
User Avatar
Hello! I am an Excel expert from the US who should be able to help you with this project without any problems. I would love to chat with you and learn more about what you are hoping to accomplish just so I don't miss any details. Thank you for the opportunity!
$250 USD in 3 days
5.0 (28 reviews)
4.5
4.5
User Avatar
Hi Good day! A serious freelancer here! I have a lots of available time for this type of work.i just need to have the full requirements so I can assess how long would it take to complete this. I am VBA Macro developer for 6 years now. I have a strong knowledge with Excel formulas and function that will help for this type of work. I am also a PMO Analyst that focused in Financial and Metrics Reports. My rate is negotiable because I'm still collecting good reviews and portfolio that I can show to my future clients, so please accept my bid. Feel free to message me to discuss more about the scope of this project. Thanks!
$50 USD in 3 days
4.9 (36 reviews)
4.5
4.5
User Avatar
Hi, Price and duration is negotiable. I am expert in Excel having 12 Yrs Professional experience. I’ll complete task with 100% Accuracy and in least possible time. I assure you, you will be another 100% satisfied client. I am regularly doing following kind of tasks: I have 4-6 separate commission reports that are all either CSV for excel files. They all have multiple columns of information but I only need 7 or so columns from each spreadsheet. Each column is named differently and in different orders between the reports. I need to extract the 7 columns that I need from each report and combine them into one master report. The 4-6 commission reports will be a new file every month. I need the information to stack on top of each other in the master report. For example, if commission report #1 has 3 sales that information will be in lines 2-4. If commission report #2 has 5 sales that information will be in lines 5-9. And so on. I need someone to create a formula or VBR or something else so I can simply choose the 4-6 separate commission reports to use in the formula and click a button. Thanks. Faisal S.
$100 USD in 3 days
5.0 (19 reviews)
4.0
4.0
User Avatar
The better solution is on Access database. You could link the sheets and merge & generate the report like you want. Then, export this to Excel file. Please, contact me and we could make a little test to show you.
$222 USD in 2 days
5.0 (8 reviews)
4.0
4.0
User Avatar
I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, charts, advance formulas, formatting, macro etc. thanks
$120 USD in 2 days
4.9 (23 reviews)
4.0
4.0
User Avatar
i can share you the required values within 2 hour i will use excel formulas for this purpose will charge you minimum amount Looking forward to hear from you. Thanks Faisal
$30 USD in 1 day
5.0 (5 reviews)
3.7
3.7
User Avatar
Hi There, I have understood your requirements. I am a Data Entry/Web Research/ Data Research and data Uploading specialist. I have years of experience in managing, updating researching & adding Online data records on CRM. I am so confident to take up this opportunity to provide you with 100% accuracy of results. I am also ready to do first 1 Hours of service as a trial free of cost to ensure you the quality and accuracy of my work before hiring me. Waiting for your response! Thanks & Regards, Samol
$100 USD in 2 days
4.2 (3 reviews)
3.0
3.0
User Avatar
Hello Sir, I'm an experienced and highly professional excel expert. I can assure you about top quality work on your project. Your project is what I'm specialized in. Can we discuss sir? Thanks
$200 USD in 3 days
5.0 (3 reviews)
2.1
2.1
User Avatar
Hello Thank you for posting. I have read your post carefully. I am familiar with Excel. I already have experience in developing something like this. And I am also a full stack developer. If you share me your site, I will check carefully. Thanks......
$150 USD in 3 days
5.0 (1 review)
1.5
1.5
User Avatar
i can help you with your project. just give me all the details needed so i can finish the work perfectly.
$30 USD in 3 days
5.0 (3 reviews)
1.3
1.3

About the client

Flag of UNITED STATES
ANKENY, United States
5.0
10
Payment method verified
Member since Jul 24, 2018

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.