Find Jobs
Hire Freelancers

Combine Excel Worksheet Figures

$10-50 USD

Abgeschlossen
Veröffentlicht vor mehr als 8 Jahren

$10-50 USD

Bezahlt bei Lieferung
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.
Projekt-ID: 8757657

Über das Projekt

33 Vorschläge
Remote Projekt
Aktiv vor 9 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
Vergeben an:
Avatar des Nutzers
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 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tag
5,0 (141 Bewertungen)
7,1
7,1
33 Freelancer bieten im Durchschnitt $30 USD für diesen Auftrag
Avatar des Nutzers
A proposal has not yet been provided
$60 USD in 1 Tag
4,9 (250 Bewertungen)
7,6
7,6
Avatar des Nutzers
A proposal has not yet been provided
$50 USD in 1 Tag
4,9 (273 Bewertungen)
7,2
7,2
Avatar des Nutzers
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 Tag
5,0 (129 Bewertungen)
6,8
6,8
Avatar des Nutzers
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 Tag
4,9 (198 Bewertungen)
6,4
6,4
Avatar des Nutzers
I can do it for you quickly and exactly by vba .
$50 USD in 2 Tagen
4,9 (105 Bewertungen)
6,6
6,6
Avatar des Nutzers
Proposal belum diberikan
$30 USD in 1 Tag
5,0 (184 Bewertungen)
6,5
6,5
Avatar des Nutzers
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 Tag
5,0 (26 Bewertungen)
6,1
6,1
Avatar des Nutzers
Sir, I m interested in this job. Give me a chance please.Thanks........................................................................................
$34 USD in 2 Tagen
4,9 (93 Bewertungen)
5,6
5,6
Avatar des Nutzers
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 Tag
4,8 (72 Bewertungen)
5,8
5,8
Avatar des Nutzers
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 Tag
4,9 (26 Bewertungen)
5,5
5,5
Avatar des Nutzers
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 Tagen
4,9 (40 Bewertungen)
5,2
5,2
Avatar des Nutzers
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 Tag
4,8 (99 Bewertungen)
5,4
5,4
Avatar des Nutzers
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 Tag
5,0 (21 Bewertungen)
4,4
4,4
Avatar des Nutzers
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 Tag
5,0 (34 Bewertungen)
4,4
4,4
Avatar des Nutzers
A proposal has not yet been provided
$25 USD in 1 Tag
4,6 (16 Bewertungen)
3,5
3,5
Avatar des Nutzers
A proposal has not yet been provided
$20 USD in 1 Tag
5,0 (5 Bewertungen)
3,4
3,4
Avatar des Nutzers
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 Tag
4,9 (15 Bewertungen)
3,6
3,6
Avatar des Nutzers
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 Tag
4,7 (2 Bewertungen)
2,0
2,0
Avatar des Nutzers
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 Tag
4,4 (1 Bewertung)
1,8
1,8
Avatar des Nutzers
A proposal has not yet been provided
$50 USD in 1 Tag
5,0 (2 Bewertungen)
1,6
1,6

Über den Kunden

Flagge von UNITED STATES
Burleson, United States
5,0
17
Zahlungsmethode verifiziert
Mitglied seit Feb. 5, 2015

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.