Excel 2003 - Need to summarize items selected on first sheet

[eholdo]

I have created a price list for a certain product, with the product description, part number and price listed on each line. There is also a column on each line for quantity. I want to take any line where they have entered a quantity, and copy that line to a master "cover page" as a summary of the proposed items.

Help!

 

[KenWright]

You are far better off simply AutoFiltering on the quantity column, and filter out Non-Blanks, or custom 'Not equal to 0' if you have zeroes in the empty ones.

Regards
Ken..............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[eholdo]

The problem is there will be multiple (up to 6) sheets which contain product options for different overall products. So I'd like to roll them all up into a single sheet. Using a button to perform the rollup to the master sheet would be fine, I'm not necessarily looking for it to be in the background.

 

[KenWright]

OK, so I'm still back on filtering, but if you really need to have 6 different sheets then have a summary sheet that links to all 6 pulling in ALL the data from all 6 but one under the other, and then again just filter on the quantity column. If you pull the quantity column data using an IF statement such as

=IF(Rngxx="","",Rngxx) or
=IF(Rngxx=0,"",Rngxx)

then you can just filter on Non Blanks on your summary sheet.

Regards
Ken...............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------