Solved

Adding values from spreadsheet and importing that value into existing workbook

Posted on 2013-11-24
5
298 Views
Last Modified: 2013-11-24
I have to track gas usage using an excel 2007 workbook.  In the master workbook i have each piece of equipment and a gas card number for that specific piece of equipment in one row.  I download the expenses for the month from our creditor (in excel format) that has the same gas card number as in my workbook however, they are in no specific order.  I want to rename the spreadsheet from the creditor to the month that it pertains to (i.e. January) and import the data into the master workbook.  The creditor doesnt add all the expeditures for each gas card.  It has each purchase on an individual row.  I would like to use a formula in a cell in the master workbook that looks in January for the gas card number in column A and adds all the values it finds that are in column D together for that specific card.
0
Comment
Question by:prodatahs
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 5

Expert Comment

by:Lawrence Barnes
ID: 39673515
Sounds like you need the sumifs function.  Do you intend for all of the months to be in different tabs and to add to the formula for each month or have the master sheet have columns for each month?  If it is a low row count (ten thousands per month) then the gas purchase data could all be in one sheet so long as each row has a date on it.

If you upload a sample spreadsheet I can post the formulas directly.
0
 

Author Comment

by:prodatahs
ID: 39673558
In the master, each month has its own tab.  Each device is on it own row.  I will have worksheets from the creditor for each month as seperate files such as January, february, etc.
The master takes the whole years expenses for each piece of equipment.
0
 
LVL 5

Accepted Solution

by:
Lawrence Barnes earned 500 total points
ID: 39673577
Attached is a file with one sheet posing as the Master January and the other sheet posing as as the creditor (Fuel Records January).  If you are using separate files you can edit edit the formula to point to a different spreadsheet.
SUMIFExample.xlsx
0
 

Author Comment

by:prodatahs
ID: 39673595
That was it exactly.  Thank you for your help!!
0
 
LVL 5

Expert Comment

by:Lawrence Barnes
ID: 39673603
Thanks for the points!
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question