I have a ever expanding workbook which lists material description, part
number, cost, number of units (to order) and total amount for that item row.
Is there a way I could compile only the item rows with a unit value (number
of those items to be ordered) to a summary sheet that would list only the
item rows of the materials I want to order. I currently use auto-filter
(non-blanks) in the units column but it generates a seperate sheet for each
page that has a item or items to be ordered, based on the units column. Most
of my orders would consist of a single page, if the rows could be compiled,
rather than multiple single line pages. I can't imagine Excel isn't capable
of performing this task. Thanks All!