Hi, here is the problem:
I am creating a budget spreadsheet. The user needs to fill in fields for vendor, GL (budget) code, and amount.
I am trying to make the GL codes into a drop down list. What complicates this is that I want the amount to be grouped and summed by the drop list selections into another part of the sheet.
To clarify with example...Say there are 3 entries to be made. There are 4 GL codes total, ie: 1,2,3,4. My data to be input is as follows (vendor, GL, amount):
Office Max, 2, $5
Home Depot, 1, $2
Staples, 2, $6
Note again that the GL codes (the second criteria in the data example) are drop down choices. Somewhere along the bottom of the sheet I want a summary of costs per GL code. So for GL code 2, I'd get $11 and so forth.
Upon looking around, it seems I might need to use VB, but I am not very familiar with it yet. Any suggestions would be greatly appreciated.
I am creating a budget spreadsheet. The user needs to fill in fields for vendor, GL (budget) code, and amount.
I am trying to make the GL codes into a drop down list. What complicates this is that I want the amount to be grouped and summed by the drop list selections into another part of the sheet.
To clarify with example...Say there are 3 entries to be made. There are 4 GL codes total, ie: 1,2,3,4. My data to be input is as follows (vendor, GL, amount):
Office Max, 2, $5
Home Depot, 1, $2
Staples, 2, $6
Note again that the GL codes (the second criteria in the data example) are drop down choices. Somewhere along the bottom of the sheet I want a summary of costs per GL code. So for GL code 2, I'd get $11 and so forth.
Upon looking around, it seems I might need to use VB, but I am not very familiar with it yet. Any suggestions would be greatly appreciated.