Dynamic dropdown list

Originally Posted by jindon

Try the attached.
No restriction of 256 characters even if the list grows bigger and bigger.

Dear Sir,

Thanx for the reply.Pls find enclosed in attachment,slight alteration with 4 sheets added where result is to be achieved.Kindly state the steps too as how to copy the same code in my original workbook.I could have share that original but since the data is too big,I cannot disclose the data as per my company norms.Hope you understand.

Pls let me know the steps for this enclosed workbook whose format is exact the same as in my real spreadsheet which contains same matching condition data but >1800 rows & will grow as the user daily goes on feeding the data.

1.'Details' sheet which has matching conditions data in Column A,C,D (same as that was in above mentioned workbook in A,B & C Column in sample sheet)

But Results to be obtained in below 4 sheets mentioned a slightly different sheets in different columns instead of F,G and H column which was done in existing sample worksheet.

2.'Printing'
3.'Lamination'
4.'Pouching'
5.Finish

Hoping a positive reply.

With Best Rgds.
Suresh