Macro with multiple loops

[Dhawal Sharma]

Hi Ninjas!

I seek help from this community to help me with one of the macros I wish to make.

I have summed up the context and the requirements in the attached workbook.
Yeah, its good amount of information. But I feel you will be able to connect better with the objectives this way and guide me better.

In short: I have to allocate stock to my orders while following a particular priority and a set of conditions.
Details as in the workbook.

Thanks beforehand for your kind assistance.
Dhawal Sharma

 

[vletm]

Dhawal Sharma
This seems to be 2nd part of ...

I quickly checked that file ...
LOOP 1 Select Each PDNO in ascending order (priortization)...
I didn't find from any sheet's table PDNO ...
... hmm= ... 'Tool requirements' has PDNO, but there are only two!
... ... so, that won't meant same PDNO! ... hope so!

Did You write those texts for Youself or for others?
... this looks interesting,
and even this should be possible!
BUT, You should open those texts for others ...

> Ideas? <

 

[Dhawal Sharma]

Hi vletm

You are correct. these are connected. Its actually a first part to...

I didn't find from any sheet's table PDNO ...
>> I should have specified. PDNO = Main item Pdno = Q colm of Order data sheet.

LOOP 1 Select Each PDNO in ascending order (priortization)...
>> A slight change here as well.
LOOP 1 Select Each PDNO in ascending order of the Sequence no. (priortization)..
Sequence no. = R colm of Order data (This I missed to provide in earlier file, apologies )

... hmm= ... 'Tool requirements' has PDNO, but there are only two!
... ... so, that won't meant same PDNO! ... hope so!
>> Those two are just for example sake. which I used to explain my requirement. Thats not actual data.


Did You write those texts for Youself or for others?
>> Sorry, Which text are you referring to?
The tool requirement and macro logical structure I made for reference and documentation. (If thats what you referred to)

I have attached updated worksheet (added sequence no. this time)
All relevant fields are marked yellow in data files for order and stock.

Thanks

 

[vletm]

Dhawal Sharma
Terminology!
If terms are exact same in everywhere
then this would be quicker for You
... exact mean exact!

Q: Which text are you referring to?
A: All texts! for 'as free job' those are challenge!

This seems to be something as previous case
and
I could continue only as with previous case!

 

[Dhawal Sharma]

Hi
I have included a reference data to give info on which colm is where in data. I hope that will be helpful.

DO let me know if any clarification required in any of the text. I given my best shot here


I could continue only as with previous case!
>> About that. I feel its a different problem statement. The earlier one was about scheduling.
This one is stock allocation which requires multiple loops.


Thanks
Dhawal

 

[vletm]

Dhawal Sharma
I could continue only as with previous case!
... and that was in conversations.
This will take more than 10 replies from You.

Previous was previous and
You started to use 'not ready version' ... by Your choice.