looking for a way to take what i need on a shopping list and show it as a list elsewhere.

[DanielR.]

So i've been at this for a while now and i give... I have a inventory list for shopping that i have been working on to automate. As of now everything is fine but i want to know if there is a way to sort out only the items that are needed to a spot
on excel. For example i have the product in column A, and qty needed in column D. my hopes are i can show only what is needed to order starting at cell H27 where it will include the product from Column A based on if D shows greater than zero. however will not populate anything if the value is zero and will simply look over it. Thanks for any help in advance.

Situation:
Eggs | 1 |
Milk | 1 |
Strawberry | 0 |
Bread | 2 |

Hopes: (will not show strawberry as it has a zero value and will not show up)
Eggs | 1 |
Milk | 1 |
Bread | 2 |

[Logit]

.
Folks sometimes get confused when questions are asked and fail to answer all of the questions. Answering helps our understanding.

#1 What is the purpose of copying what is ordered to H27 ?

#2 Please post a copy of your workbook with existing format and how it should look after you input the order ?

#3 You may be able to simplify everything buy just having A : D columns. Then using the DATA FILTER, you can show only those rows marked as 'Ordered' and if
necessary, print just those rows.

[DanielR.]

Hey Logit,

H27 would be where i would like the condensed list of what needs to be ordered to start. I know some may try to write out the formula so i just threw it there in case of that.

Untitled.png - not sure if this image will work. Will change if not.

I order all my items online so i dont really print them out. Rather than going line by line i was hoping there was some way to show only what needs to be ordered in the other area.

If any more question i can help clarify let me know. Or if a specific function could be used i can research on how it works on my own to save others some time.

Thanks again.
Daniel

[Logit]

.
This works well here :

Please Login or Register  to view this content.

[DanielR.]

Logit,

Pretty darn close... when i change something to 2 or more it doesnt show.

[JohnTopley]

Change

shA.Range("$A$5:A" & LastRow).AutoFilter Field:=1, Criteria1:="1"

to

shA.Range("$A$5:A" & LastRow).AutoFilter Field:=1, Criteria1:=">0"

[DanielR.]

Amazing... Thanks Logit and John. Made my wife very happy. Thread solved.

[Logit]

.
John .. thanks for the assist.

You are welcome Daniel.

Cheers.