Build a single order sheet from a multiple page material list.

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!

You could always use the autofilter, then copy those visible cells to a new
worksheet and print from there.

But it sounds like you have manual page breaks on your worksheet. If you remove
them, then you can use that worksheet and autofilter, then print.



Ralph-novice wrote:
>
> 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!

--

Dave Peterson