Moving Data

[Guest]

I have a workbook with 9 worksheets in it. The first worksheet is where I need all information that is entered below 0 zero (Column E) to be pulled to the front worksheet. How can I do this? My worksheets are all set up like this..

1 A B C D
2 Item # Description Qty on hand Qty needed Orde
3 4 Teletype Paper 0 25 -2
4 5 8.5X11 COPY 2 10 -

What I need is everything in column E that is zero or below to show on the first worksheet for easier access to ordering.

If you need more infortmation let me know

Thanks!

 

[Dave Peterson]

I'd recreate that first worksheet each time it needed to be refreshed.

If you apply Data|filter|autofilter to each worksheet, you could filter on that
column for less than 0 and copy the visible rows to the first worksheet.

If you needed a macro, you could record one when you did it once. Post back if
you need help.