Hi,
I'm trying to create a summary sheet of a form with only the rows that contain data. We have a sheet with an order form for different parts pre-listed in each row (i.e. Row 1 is a Hammer, Row 2 is a Nail, etc. going down a few hundred rows). When an order is placed we indicate quantity in the appropriate row. Instead of printing all of the pages, ideally I'd like to create a summary report on a different sheet just showing the rows that have a quantity data.
Is there a formula that could do this? I'm familiar with sorting by column, perhaps pivot table or even a macro, but if there is a formula for this that would be ideal.
Thank you in advance for you help,
Lloyd
I'm trying to create a summary sheet of a form with only the rows that contain data. We have a sheet with an order form for different parts pre-listed in each row (i.e. Row 1 is a Hammer, Row 2 is a Nail, etc. going down a few hundred rows). When an order is placed we indicate quantity in the appropriate row. Instead of printing all of the pages, ideally I'd like to create a summary report on a different sheet just showing the rows that have a quantity data.
Is there a formula that could do this? I'm familiar with sorting by column, perhaps pivot table or even a macro, but if there is a formula for this that would be ideal.
Thank you in advance for you help,
Lloyd