Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Where do I start
I am creating a workbook and need some help.
Sheet 1 is where I enter data (qnty of products made is then broken down into its composite parts and their qnty) eg below CELL A1 = CASES MADE = 1 CELL A3 = CASE TYPE A = 1 CELL A4 = LABEL TYPE A = 2 CELL A5 = CASE LINER A = 1 CELL A6 = OTHER ITEM A = (NO FIGURE INPUT) I would enter the same type of info for several products each using the same components. I would like to summerise the total qnty's on a seperate sheet to print out Only those items that have a figure input next to them. to look like the example below HEADING = TOTAL QNTY'S USED CASE TYPE A 100 LABEL TYPE A 25 CASE LINER A 100 I hope someone has an idea of how to do this. Thanks Julian |
#2
|
|||
|
|||
I am creating a workbook and need some help.
Sheet 1 is where I enter data (qnty of products made is then broken down into its composite parts and their qnty) eg below CELL A1 = CASES MADE = 1 CELL A3 = CASE TYPE A = 1 CELL A4 = LABEL TYPE A = 2 CELL A5 = CASE LINER A = 1 CELL A6 = OTHER ITEM A = (NO FIGURE INPUT) I would enter the same type of info for several products each using the same components. I would like to summerise the total qnty's on a seperate sheet to print out Only those items that have a figure input next to them. to look like the example below HEADING = TOTAL QNTY'S USED CASE TYPE A 100 LABEL TYPE A 25 CASE LINER A 100 One way is to use a pivot table report. Data Pivot table report Excel has built-in help on pivot tables. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Start spreadsheet with WinXP start | Excel Worksheet Functions | |||
I deleted MS Outlook from my start menu, now EXCEL won't work? | Excel Discussion (Misc queries) | |||
Help! Excel 2000 fully SP'ed will not start | Excel Discussion (Misc queries) | |||
sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
Inserting Blank Rows Macro? | Excel Worksheet Functions |