Order Sheet

Hi,

I have an excel file I use every week as an order sheet. I rename the file each week to keep each week separate. I suspect not the best way to do it but that works for me,

Within the file, contains a sheet showing every product one of my suppliers stocks (tobacco). Each week I enter my requirements next to each product and my pal gives me his order and I enter his requirements too (separate column). A simple formula adds my order with his on each line to get the total. I then go through the file and copy and paste the items as requirements into an email. Its the copy and pasting bit I think there must be an easier solution. Bear in mind, the supplier stocks 100's of items, between us we stock them all, but don't order them all every week.

So to summarise, I have a large sheet, with lots of products and somehow need to get only the ones ordered into an email along with the quantity required.

Perhaps a way of copying the items ordered into another sheet, creating "the order", so as the requirements are entered into the product sheet, the order starts being created on the oteher one??

Thanks in anticipation ...

One way
Used data filter to filter out the lines you do not want:
from:
Unfiltered.jpg

to:
Filtered.jpg

by
selecting "Data" tab ...
clicking on "Filter" ...
click on arrow at top of Quantity column ...
select "Number Filter" .... "Greater than"
set value = 0
quantity_greater_than_0.jpg

When you copy the selection, only the visible rows are pasted

Thanks, your a star !!

I use filtering a lot, but wasn't aware of the greater than option.

I think this will work well

Thanks

Craig

You are welcome

Please mark the thread as solved (top of thread, under Thread Tools)