PN Generator

[Kmahraz]

Hi Folks:
Looking for an easy way to generate PN configuration based on data validation.
It may be hard to explain but please see attached file to get a better idea of what I am trying to achieve.
please let me know if there are any questions.
Thanks
K

 

[Hui]

Pls see attached file

It uses name ranges a lot to hold the Lists and the count of the items in each list
so check them out

 

[Kmahraz]

Hello Hui:
First thank you so much for the great solution, but I found several duplication's, please see picture below:

 

[Hui]

Whoops

Please change:

B11: =INDEX(A_,MOD(INT((ROW()-11)/(BC_*CC_*DC_)),AC_)+1)
D11: =INDEX(B_,MOD(INT((ROW()-11)/(CC_*DC_)),BC_)+1)

Copy both down

 

[Kmahraz]

Thank Hui, That worked perfectly.
Much appreciated