Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Creation
I'm looking to create a macro with a sumif function (among maybe other
functions) incorporated into the code. If you could please help, I would appreciate it! Here's what I'm looking at: in column A I have a list of items: Selling Salaries Store Manger Salary Asst Manager Salary Employee 1 Salary Employee 2 Salary Utilities Phone - Regular Internet Postage (etc, etc ...) In Column B, I have the categories by which these items are assigned Payroll Payroll Payroll Payroll Payroll Office Overhead Office Overhead Office Overhead Office Overhead (etc, etc...) In column C, I have all of the $ amounts associated with these costs. I'd like these values in column C added together (probably best with sumif formula) based off of their assigned categories. Then, if it's possible, I'd like to consolidate the information in column A to read what the category is in column B. So, the end product reading: Column A Salary Overhead Column B $$ (sum for Salary) $$ (sum for Overhead) Thanks for your help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Creation
Seems like a pivot table should work for you. Look at these tutorials:
http://peltiertech.com/Excel/Pivots/pivottables.htm http://www.babeled.com/2008/07/18/ex...-manipulation/ HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Liz J" wrote: I'm looking to create a macro with a sumif function (among maybe other functions) incorporated into the code. If you could please help, I would appreciate it! Here's what I'm looking at: in column A I have a list of items: Selling Salaries Store Manger Salary Asst Manager Salary Employee 1 Salary Employee 2 Salary Utilities Phone - Regular Internet Postage (etc, etc ...) In Column B, I have the categories by which these items are assigned Payroll Payroll Payroll Payroll Payroll Office Overhead Office Overhead Office Overhead Office Overhead (etc, etc...) In column C, I have all of the $ amounts associated with these costs. I'd like these values in column C added together (probably best with sumif formula) based off of their assigned categories. Then, if it's possible, I'd like to consolidate the information in column A to read what the category is in column B. So, the end product reading: Column A Salary Overhead Column B $$ (sum for Salary) $$ (sum for Overhead) Thanks for your help! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Creation
You're right. I overcomplicated it. Thanks, Ryan.
"ryguy7272" wrote: Seems like a pivot table should work for you. Look at these tutorials: http://peltiertech.com/Excel/Pivots/pivottables.htm http://www.babeled.com/2008/07/18/ex...-manipulation/ HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Liz J" wrote: I'm looking to create a macro with a sumif function (among maybe other functions) incorporated into the code. If you could please help, I would appreciate it! Here's what I'm looking at: in column A I have a list of items: Selling Salaries Store Manger Salary Asst Manager Salary Employee 1 Salary Employee 2 Salary Utilities Phone - Regular Internet Postage (etc, etc ...) In Column B, I have the categories by which these items are assigned Payroll Payroll Payroll Payroll Payroll Office Overhead Office Overhead Office Overhead Office Overhead (etc, etc...) In column C, I have all of the $ amounts associated with these costs. I'd like these values in column C added together (probably best with sumif formula) based off of their assigned categories. Then, if it's possible, I'd like to consolidate the information in column A to read what the category is in column B. So, the end product reading: Column A Salary Overhead Column B $$ (sum for Salary) $$ (sum for Overhead) Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro creation help | Excel Programming | |||
Macro creation | Excel Worksheet Functions | |||
Creation of macro with an example | Excel Discussion (Misc queries) | |||
Macro Creation | Excel Discussion (Misc queries) | |||
XML creation via a macro | Excel Programming |