Combine Excel Worksheet Figures
$10-50 USD
Płatność przy odbiorze
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.
Numer ID Projektu: #8757657
O projekcie
Przyznany użytkownikowi:
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 wi Więcej
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
33 freelancerów złożyło ofertę za $30 w tym projekcie
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
Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?
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 Więcej
Sir, I m interested in this job. Give me a chance please.Thanks........................................................................................
Hi, I am interested to do this task. I can start working right away after being awarded. Hoping for your reply. Thank you.
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 va Więcej
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? Be Więcej
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
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 wit Więcej
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 co Więcej