Moving Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
 
Back
Top