Find Jobs
Hire Freelancers

Combine Excel Worksheet Figures

$10-50 USD

Completed
Posted over 8 years ago

$10-50 USD

Paid on delivery
I have about 25 Excel Work books. Each work book has a list of Government contractors with sales figures of products and or services sold to the government. Each work book is named by a number (example 132-8) which indicates various types of groups under Information Technology (IT products, IT Software, IT services, Etc). Each contractor has a unique number called a GSA Number. I need an Excel Template that I can use regularly that will total the sales figures for each GSA Number of all spreadsheets. So the final spreadsheet should combine the total sales for each GSA number of all 25 work books. The idea is to give a total each contractor sells to the U.S. Government.
Project ID: 8757657

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
Dear hiring manager after care fully review your job description and requirement and i feel that i am a sutable match for this job.I am expert in data entry , ms word , ms excel, internet research. i do your job within lowest rate. I am new but i am hard worker. Regard,s MD:Mithun Ali
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. If the number of files (which is 25 at the moment) is static, then we can establish some formulas to retreive the data. Pretty easy. Just contact me
$50 USD in 1 day
5.0 (141 reviews)
7.1
7.1
33 freelancers are bidding on average $30 USD for this job
User Avatar
A proposal has not yet been provided
$60 USD in 1 day
4.9 (250 reviews)
7.6
7.6
User Avatar
A proposal has not yet been provided
$50 USD in 1 day
4.9 (273 reviews)
7.2
7.2
User Avatar
Hello, I think better we'll use Pivot table for this task (you have Excel 2007 or later). Please open chat with me so that I can show you the sample work. Best regards, Hoang
$30 USD in 1 day
5.0 (129 reviews)
6.8
6.8
User Avatar
Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?
$25 USD in 1 day
4.9 (198 reviews)
6.4
6.4
User Avatar
I can do it for you quickly and exactly by vba .
$50 USD in 2 days
4.9 (105 reviews)
6.6
6.6
User Avatar
Proposal belum diberikan
$30 USD in 1 day
5.0 (184 reviews)
6.5
6.5
User Avatar
assuming, 132-51 is an IT services. So, there are 25 different workbooks, representing your center. I'll design a template spreadsheet to link all 25 workbooks, and show you the total Sales for each contractor. there are two ways 1) gather all information from each worksheet automatically and show you the total result for each contractor (total as well as IT Center wise) 2) link workbooks into one, and show consolidated picture within that. It will automatically update if the course file is updated. hope to win the bid thanks
$30 USD in 0 day
5.0 (26 reviews)
6.1
6.1
User Avatar
Sir, I m interested in this job. Give me a chance please.Thanks........................................................................................
$34 USD in 2 days
4.9 (93 reviews)
5.6
5.6
User Avatar
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$24 USD in 1 day
4.8 (72 reviews)
5.8
5.8
User Avatar
Hi, I am interested to do this task. I can start working right away after being awarded. Hoping for your reply. Thank you.
$35 USD in 1 day
4.9 (26 reviews)
5.5
5.5
User Avatar
Hello, I have been working as freelancer since last ~ 2.5 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- EXCEL VBA -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$45 USD in 3 days
4.9 (40 reviews)
5.2
5.2
User Avatar
Sample can be shared Available now to contact (Chat/PM) and start the project. Also please do look at my portfolio for my past work and 100% satisfied reviews from earlier projects ***SPECIAL NOTE*** - Quickest delivery time than anyone who will bid. You can be rest assured the quality of the project will be top class and will be delivered as per the timeliness. Also I will be available for any modifications which you require during the project.
$12 USD in 1 day
4.8 (99 reviews)
5.4
5.4
User Avatar
Hi, I can create a small macro that will scan each file in a folder and create a table that shows each GSA and their totals using groups as column name and then adding all of them. Is that what you require? Best Regards,
$18 USD in 1 day
5.0 (21 reviews)
4.4
4.4
User Avatar
Hi, I am interested in your work. I done your work as per your requirement also within time and budget. Contact me. Thanks and Regards Asif
$35 USD in 0 day
5.0 (34 reviews)
4.4
4.4
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
4.6 (16 reviews)
3.5
3.5
User Avatar
A proposal has not yet been provided
$20 USD in 1 day
5.0 (5 reviews)
3.4
3.4
User Avatar
I will provide you VBA macro script under windows excel which will allow you to select a folder which may contain any number of files (25 or any other number). The script will handle any number of rows in each file with one click.
$18 USD in 1 day
4.9 (15 reviews)
3.6
3.6
User Avatar
I am a Project Manager in profession working at one of the world's largest I.T. firms. I have more than 10 years of experience in academic writing and Data Entry and ensure that quality work is delivered always. Give me an opportunity; I will deliver you the quality. Also, I have expert writers in academic topics, Data Entry experts and provide best quality content. We honor the delivery time commitment and work with you closely to understand your specific needs.
$25 USD in 1 day
4.7 (2 reviews)
2.0
2.0
User Avatar
I am ready with the job .. Lets discuss your job in detail .then pass me a sample work so that i show my work to you. finally we can discuss the payments as well as the milestones.. please don't hesitate to contact me, thank you.
$25 USD in 1 day
4.4 (1 review)
1.8
1.8
User Avatar
A proposal has not yet been provided
$50 USD in 1 day
5.0 (2 reviews)
1.6
1.6

About the client

Flag of UNITED STATES
Burleson, United States
5.0
17
Payment method verified
Member since Feb 5, 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.