Loop until quantity needed met - count in multiples based on item

**phbryan** · 09-21-2021, 03:10 PM

Hello,

I'm looking for a macro that can go down the list of items in the "Need" sheet, determine how many repeats of that item based on the "count by" sheet, and put the result in sheet4. The macro needs to do this for every item in column A of the "Need" sheet.
An example of the result I am looking for is the "desired output" sheet.

Thank you for any help!

**WideBoyDixon** · 09-21-2021, 04:32 PM

Here's a commented macro that should do pretty much what you're after:

Please Login or Register  to view this content.

WBD

**phbryan** · 09-21-2021, 08:05 PM

Thank you WBD for the detailed response! This does pretty much what I need.
To answer your question, "don't over order if it's not an exact multiple?" - Overordering is fine. In fact overordering is preferred and I need to stay in exact multiples.

**WideBoyDixon** · 09-22-2021, 04:55 PM

OK. Then this line changes:

Please Login or Register  to view this content.

WBD

**phbryan** · 09-22-2021, 10:43 PM

Hey WBD,

I have a couple of special cases where the order multiple is zero. In this case, I want to skip the item. Right now the macro gets stuck in a loop, constantly subtracting by zero.

**WideBoyDixon** · 09-23-2021, 02:20 AM

Please Login or Register  to view this content.

WBD

**kvsrinivasamurthy** · 09-23-2021, 04:02 AM

Order multiple of A4 in "Count by" sheet is zero. Hence it will not be displayed.

Try this Code

Please Login or Register  to view this content.

**phbryan** · 09-23-2021, 02:23 PM

WBD,

I see you added the Elseif to check for zero's. The logic makes sense, but the macro doesn't run.
Maybe is just on my side?
See attached

**WideBoyDixon** · 09-23-2021, 02:35 PM

Oops. Should have tested it! See attached.

WBD

**kvsrinivasamurthy** · 09-24-2021, 12:28 AM

Code made faster.
Order multiple of A4 in "Count by" sheet is zero. Hence it will not be displayed.

Try this Code

Please Login or Register  to view this content.

Loop until quantity needed met - count in multiples based on item

LinkBack

Thread Tools

Rate This Thread

Display

Loop until quantity needed met - count in multiples based on item

Re: Loop until quantity needed met - count in multiples based on item

Re: Loop until quantity needed met - count in multiples based on item

Re: Loop until quantity needed met - count in multiples based on item

Re: Loop until quantity needed met - count in multiples based on item

Re: Loop until quantity needed met - count in multiples based on item

Re: Loop until quantity needed met - count in multiples based on item

Re: Loop until quantity needed met - count in multiples based on item

Re: Loop until quantity needed met - count in multiples based on item

Re: Loop until quantity needed met - count in multiples based on item

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula to count hours/minutes based on multiples cells and instances

[SOLVED] Simple formula needed to count cells based on item names in other cells

[SOLVED] I need help on a formula where I find an item and quantity based on a specific date

Auto decrease quantity of an item when the item is sold.

[SOLVED] VBA To populate listbox with duplicate item by increasing the item quantity

FIFO value by item computed from observed quantity by item and purchase information

fifo value by item computed from observed quantity-by item and-purchase information

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions