Dynamic dropdown list

[paradise2sr]

Dear Sir,

Currently I am facing with dropdownlist problem.I have posted at http://www.excelforum.com/excel-form...alidation.html but could not be able get the desired solution.I think I might get solution at VBA forum hopefully.

As enclosed in attachment,I want result in F3 and G3.Currently I have shown single data in E3.There will be data in E4,E5,E6...... and so on.The data to be displayed in F3 and G3 should be in dropdown list which I tried using data validation but could not able to do so and omitted lateron.The lookup data are in A,B and C column.

Rest of the things I have explained in comment in F3 and G3.

Hope,I could able to achieve the result.

With Best Rgds,

Suresh

[MickG]

Try this:-

[jindon]

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

[paradise2sr]

Try this:-

Dear Sir,

Thanx for the reply to my post.It works fine F3 and G3 when the cell contains data in E3.But when I put data in E4, the dropdownlist does not display correct list in F4 and G4.Hence be noted that data will be filled by the user in E3,E4,E5,E6,E7,E8 & so on.So,the correct list must be displayed in the corresponding F and G columns rows.

It should be further to be notified to you that here Matching conditions is currently uptill at A18,B18 and C18 .It might be more than this in my real spreadsheet say more than 2000 as day to day data will be filled.

Hence I think,other cells are missing something which I think you can correct it.

Hope for the best.

With Rgds,
Suresh

[paradise2sr]

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

[jindon]

See if this is how you wanted.

[paradise2sr]

Oh!Sir,

Kindly take A,C and D column data only(Order no,Party name,Job Name) of "Details" sheet as B column contains Date which I do not require to match except A,C and D of 'Details' sheet.Pls see the labels also in the corresponding sheets of

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

Also it is not compulsory to be dropdown for Order no. lebelled as it will be feeded manually only the dropdowns of compulsory for labelled 'Party Name' and 'Job Name' is required.

Also delete F,G,H column of 'Details' sheet as I do not require my result over here.I require only in 4 sheets mentioned.

Hope this now has been further been cleared and will revise accordingly the workbook formula.
Thanks once again to you.

With Best Rgds,
Suresh

[jindon]

try this then

[paradise2sr]

try this then

Thanx for the reply.This perhaps will work.In 'Printing' of Order No labelled in E3.Can you just revise your formula for making manual typing in E4 and onwards instead of dropdown list (likewise the same for Lamination,Pouching and Finish sheet) whereas others dropdownlist labelled under Party Name and Job Name seems fine at the moment.

Until then I will copy the formula today in my original workbook and see what is the effect.

I hope this minor changes will be done by you easily.

With Best Rgds,
Suresh

[jindon]

If you want to understand how the system works, do a step debug.

[paradise2sr]

Dear Sir,

I am copying your formula but there is something wrong.I am just checking it.

I am very much thankful to you.

With Best Rgds,
Suresh

[jindon]

Delete your email address immediately and I will not give you my email anyway.
You can ask question on the board only.

[paradise2sr]

Delete your email address immediately and I will not give you my email anyway.
You can ask question on the board only.

I have deleted it.A stepwise instructions to implement will be highly appreciated.

With Best Rgds,
Suresh

[jindon]

Make sure you copy the code everything in;

1) Standard module, Module1
2) ThisWorkbook module, Workbook_Open and Workbook_SheetChange
3) Worksheet module in "detail" sheet, Worksheet_Change and GenerateNames

If you miss any one of the above, the system won't work.

[paradise2sr]

Do I have to create any sheet also or not.Becoz I found one hidden sheet named as hiddennames.

I will marked as solved as soon as I fully get into my original workbook done.

With Best Rgds,
Suresh

[paradise2sr]

Make sure you copy the code everything in;

1) Standard module, Module1
2) ThisWorkbook module, Workbook_Open and Workbook_SheetChange
3) Worksheet module in "detail" sheet, Worksheet_Change and GenerateNames

If you miss any one of the above, the system won't work.

Dear Sir,

I have duly copied all the code but there has been error of Sheet1 which was of 'Details' but still there it exists.I have now enclosed my original workbook where I am actually working.I have other worksheets also which I require is currently I have made hiddenas it does not require.Also in 4 worksheets I have grouped the data as already I have filled up the data.Other unncessary column data I have deleted which is not required.All other formats are as of earlier.

Hope you can correct the error in this workbook and help me to resolve it.

With Best Rgds,
Suresh

[jindon]

When you ask question and if you are not familiar with vba, you need to show us.

1) Correct data layouts. (no problem with dummy data as long as data type are the same)
2) Correct sheet names, Case sensitive.

Otherwise, you will be asking to fix errors endlessly.

[paradise2sr]

When you ask question and if you are not familiar with vba, you need to show us.

1) Correct data layouts. (no problem with dummy data as long as data type are the same)
2) Correct sheet names, Case sensitive.

Otherwise, you will be asking to fix errors endlessly.

Dear Sir,

I am extremely sorry,if I hurt you.I could not be able to figure out the code where I underlooked.I think now I would able to save time with your consistence help.

Thanx once again for deliverying your precious time to my queries.

With Best Rgds,
Suresh

[paradise2sr]

Dear Sir,

I have been using Post #17 till now is much worthy to me and working with fine as on date.

I require little bit changes in the code that in dropdown in next four consecutive sheet I want to be used PROPER Excel command to be shown.As in the 'Detail'Sheet all the data are in Capital letters.I mean to say that in dropdown list it must not show all the letters in capital letter.Instead a 'PROPER' Excel command is needed to be built in vba.

Kindly help me in this regard for modifying the code.

With Best Rgds,
Suresh

[jindon]

Replace Sub GenerateNames() in "Detail" sheet module with

Please Login or Register  to view this content.

[paradise2sr]

That really was wonderful.Thanx a lot once again to you.

[paradise2sr]

Dear Sir,

As on date 27.5.2015,My list is growing more than 4000 and there is hanging problem.The file opens and it takes more than 1/2 hours and sometimes it won't open.
There is no problem in the code u supplied but since the data grows hanging problems in opening excel file gets continue.

How can I resolve this issue ?

If you have any idea to deal with such large data,kindly let me know.