Excel help - Work ordering from suppliers

Adam123

Adam123

Adam123

Associate
Joined
11 Jan 2009
Posts
884
Hello,

When we place orders at work we have a very long spreadsheet that the supplier sends us (it contains around 500 or so items in a dirty long list broken up into slightly smaller categories (list contains product number, description, cost and units required))...
We usually only order around 30-50 items and we do this by phone, so it takes longer than it should to scroll through the list looking for items that we need.
Is it possible to some how...

Have a different sheet/area on the page that will display all the items that we want to order in a nice neat list?

Its been a very long time since I played around with Excel so I am requesting the help of a few knowledgeable people :-)

Thanks

Adam
 
Cheers for the replies already :-)

Inserted a basic mock version ha.

So imagine this is the order sheet (but 100 times smaller)

24o8u86.jpg


How could I make it so that anything with a quantity of 1 or higher is displayed in a pretty self populating list (for example column G being product code, H description, I price, J quantity of just the items we need).

With the end result being a neat and tidy list on just the items we want.

My idea is that it will form a nice template that I can send out to use as a standard ordering sheet both inhouse and possibly to the suppliers.

Thanks

Adam
 
So yeah like the way applying a filter displaying anything with >=1 is displayed, but if it could do it by its self that would be splendid :)

...

I think that if I were to have 2 sheets set up, sheet one as the original order list and sheet 2 as a duplicate with the filter applied, that may actually do what I am after :-)
 
Adam123 said:
So yeah like the way applying a filter displaying anything with >=1 is displayed, but if it could do it by its self that would be splendid :)

...

I think that if I were to have 2 sheets set up, sheet one as the original order list and sheet 2 as a duplicate with the filter applied, that may actually do what I am after :-)
Click to expand...

Edit:

Doesn't seem to auto-update if I value is changed on sheet 1 after the filter has been applied...
 
You must log in or register to reply here.
Back
Top Bottom