T
trigger
I want to make a worksheet that will summarize the data from tw
spreadsheets, called "cars" and "parts", which have three columns each
one for description, one for SKU, and one for quantity.
I'm trying to make a third worksheet display only those rows with
quantity of greater than 0. I want to split the third summary workshee
into two vertically split sections, one for cars, one for parts. I nee
to subtotal the "parts" and subtotal the "cars" sections, and the
make
a grand total.
I want this to be a dynamic worksheet, so if you change the quantity o
a line item in "cars" or "parts", it will automatically show up in th
third summary worksheet.
Please help! This has been driving me nuts for a while now. I don'
even know where to start, is it macros, VB script, or simple fuction
that can save me
spreadsheets, called "cars" and "parts", which have three columns each
one for description, one for SKU, and one for quantity.
I'm trying to make a third worksheet display only those rows with
quantity of greater than 0. I want to split the third summary workshee
into two vertically split sections, one for cars, one for parts. I nee
to subtotal the "parts" and subtotal the "cars" sections, and the
make
a grand total.
I want this to be a dynamic worksheet, so if you change the quantity o
a line item in "cars" or "parts", it will automatically show up in th
third summary worksheet.
Please help! This has been driving me nuts for a while now. I don'
even know where to start, is it macros, VB script, or simple fuction
that can save me