I'm lost!

[Glen Sharpe]

I currently have an order sheet I use in my business.
It consists of almost 400 rows of items with column b being part #, C being
description, D being cost of item, E being quantity i need to order and F
being the total $ amount of each item ordered.
I would like to condense the data of the items I order into another
area of the worksheet to summarize it.
An example would be ordering 1 item on row 7, no items on row 8 through
15 and ordering 3 items on row 16. How would I get this to appear on another
area of the worksheet and only show the items I need to order? Thanks!

 

[aaron.kempf]

throw excel out the window, pick up a book on Access. And DONT EVER
LOOK BACK.

use ACCESS for DATABASES and REPORTS.

and use Excel like you use solitaire--- all it is is a waste of time.


-aaron

 

[Bernie Deitrick]

Glen,

You don't need to show it on another area of the workbook - you can work with your data table.

Select a single cell in your table, then select Data / Filter, and Autofilter. Drop-downs will
appear at the top of your columns. Select the dropdown on column E, and choose "Nonblanks" It will
then filter your list to only show those items that are being ordered.

HTH,
Bernie
MS Excel MVP