Find Jobs
Hire Freelancers

A program that will allow the user to extract specific fields from a workbook where each worksheet is a table linked by unique identifiers

$250-750 USD

Closed
Posted over 8 years ago

$250-750 USD

Paid on delivery
I have a "database" in a workbook. Each worksheet is a table of records (rows) with fields (columns). One of the fields in each worksheet is a unique identifier that can link the record to one of the other worksheets. The relationships/unique identifiers go "two deep". I want specific fields (name, address, ...) associated with the top level record (plant or Mill) extracted from multiple worksheets and 1) placed into a single worksheet 2) with new field names (column labels; we will provide the mapping), and 3) in a format that can be imported to SalesForce.com.
Project ID: 9295551

About the project

31 proposals
Remote project
Active 8 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
31 freelancers are bidding on average $368 USD for this job
User Avatar
Hi, I am good at Excel and vba macro. I can link the sheets based on the mapping. Plz provide me the details of the worksheet and mapping file. Looking forward to work on this project.
$550 USD in 1 day
5.0 (1205 reviews)
8.4
8.4
User Avatar
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.
$400 USD in 3 days
5.0 (499 reviews)
8.0
8.0
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
$488 USD in 6 days
5.0 (235 reviews)
7.6
7.6
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, models and macros. Check my reviews. They speak for themselves. Best regards
$427 USD in 3 days
5.0 (328 reviews)
7.5
7.5
User Avatar
A proposal has not yet been provided
$500 USD in 5 days
5.0 (173 reviews)
7.4
7.4
User Avatar
Dear Sir/Madam, I have 3 years of experience in Excel VBA programming. I work as a business data analyst Ford Motor Company creating automated reports and dashboards. I can start working on your project immediately and I always work on my codes until the client is fully satisfied.
$250 USD in 7 days
5.0 (125 reviews)
7.1
7.1
User Avatar
Hi there. I am a professional programmer, with more that 7 years of experience using MS-Excel. I can guarantee you an excellent job and deliver as soon as possible. I got a general idea of what you are looking for but it will be very helpful if I could take a look at the workbooks so I can have a better understanding. I am capable of creating a program very easy to use. Hope to hear back from you soon. Thanks, Daniel
$263 USD in 3 days
4.8 (92 reviews)
7.1
7.1
User Avatar
I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I could send you samples of my work if you wish. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at some Excel projects I've done: https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$400 USD in 5 days
4.8 (179 reviews)
7.2
7.2
User Avatar
Hi: it would be great if you could share the sample. Please note that over 90% of my completed projects are related to Excel and Macro. Moreover, I have 100% completion rate and 5-star feedback on projects. Please connect with me to discuss more.
$250 USD in 3 days
4.9 (168 reviews)
7.1
7.1
User Avatar
I CAN do this job, and do it well! If you look at my portfolio You Will See That my skills are a good fit. Do You need a freelancer Who can Fulfill all of your requirements? IF SO, push the button "Hire me!" - I think it Will Be The Beginning of a good partnership !!
$250 USD in 7 days
5.0 (116 reviews)
6.6
6.6
User Avatar
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files (or the folders containing them, as required by the job) and hosting command buttons and other controls if necessary. 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 included in the bid without any additional fees. I can start working on the project immediately. If you send me a sample file and a job specification, I'm ready to create a free draft pilot for you. Regards
$250 USD in 3 days
4.9 (64 reviews)
5.7
5.7
User Avatar
Hello Thank you for the detailed explanation of your requirements. I believe I can deliver the job as per your need. I have experience with working in a RDBMS, therefore I know about linking tables with unique IDs. I get the idea that you need to pull comprehensible records based on the keys (primary/foreign). Data shall be placed on a new sheet as you explained. The output can be formatted for SalesForce upload as well. Please let me know of the 'queries' you need performed, and I'll do that. Please let me know if you are interested. Thank you & with best regards Raad *** *** *** My qualifications and experiences are as follows: I earned a good reputation from clients for the good works provided through the months (the client- feedback on my profile are a proof of that) . All of my completed works have been about using VBA to write macros that manipulate data in various ways and manners. So far in all cases the clients have been very happy with the services I provided them. I use VBA to cleanse spreadsheets, format data (based on logics) and move/manipulate them over worksheets, workbooks or office applications. The clients have been happy with my level of communication with them as well. I am always available on Skype, email, telephone or the regular messaging service from this site. Thank you
$255 USD in 5 days
5.0 (32 reviews)
5.3
5.3
User Avatar
A proposal has not yet been provided
$300 USD in 6 days
5.0 (29 reviews)
4.3
4.3
User Avatar
Dear client, I have a lot of experience with VBA and Excel. Send me a message for more information. Looking forward to work with u. Kind regards, Rens Slenders SlenDATA
$400 USD in 5 days
4.8 (15 reviews)
4.4
4.4
User Avatar
30+ years commercial business experience Expert in MS Office especially Excel University Degree in Information Systems Attention to detail a major strength Available to start immediately
$250 USD in 10 days
5.0 (5 reviews)
3.7
3.7
User Avatar
A proposal has not yet been provided
$335 USD in 3 days
5.0 (7 reviews)
3.4
3.4
User Avatar
Hello, You need someone for data entry I am an experienced data entry specialist and I am detail- oriented and meticulous in the handling of data task either from website or direct copy and paste. I have a track record of timely delivery with good quality of job. I will do a quality job that will meet your requirement by paying more attention to details. Hoping to hear from you soon.
$250 USD in 10 days
4.5 (2 reviews)
0.9
0.9
User Avatar
Hello! Can do this task for you very quickly. There can be a Windows desktop application or server-side script in result. I have wide experience in writing such utilities on C++/C#/PHP (including client-servers scripts, working with databases, web scraping, monitoring and control systems, and so on). May start working right now. Almost always online, waiting for your answer Thank you.
$250 USD in 1 day
5.0 (2 reviews)
0.8
0.8
User Avatar
La propuesta todavía no ha sido proveída
$555 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Jan 12, 2016

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.