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
|