Display automatically particular list in dropdown [SOLVED]

[paradise]

Dear Sir,

Currently,I am facing a little bit challanging work.I have a problem with regard to displaying particular list based on the input.As enclosed in attachment.In data worksheet in column C and Column D which represent list of Name of Party and Name of Job.In 'required' sheet in column C, name of party is entered manually.Now in column D in "Required" sheet,the drop down should be such that it will display only that list from Column D of "Data" Sheet that matches Column C Data from "Data" sheet with that of Column C data of "Required" Sheet which is to be entered manually.

At the moment,it has been showing all the list.I want in drop down in column D only the particular list in "Required" sheet.For e.g in required sheet.

Arbind Udhyog >>>>> in column D list should show automatically in dropdown as -

Golden Don Outer
Tinki S.S. Outer
Super Don Inner

Similary like others.

Hope this can be solved by any method.

With Best Rgds,

 

[Abdul Matheen]

Hi,

As per your query find the attached workbook with solution.


Note: to work this VBA code you need to add a reference library in VBA.
VBA Editor-->Tools-->References-->MicroSoft ActiveXData Objects 2.8 Library.



Regards
Abdul Matheen

 

[paradise]

Hi thanks for the reply.I tried your file,but it is showing error.As stated by you,I have enabled
"Note: to work this VBA code you need to add a reference library in VBA.
VBA Editor-->Tools-->References-->MicroSoft ActiveXData Objects 2.8 Library"

But the macro is showing error and not changing the list when I change the name of party.Below attached is the error that I have found.

With Best Rgds,
Suresh

 

[Deepak]

Just change this & update us to look for more approach.

fileName = ThisWorkbook.FullName

 

[Abdul Matheen]

Hi,

I have given path from my computer, edit the path in VBA. When you open the VBA editor click on sheet required there u will find path like this "fileName = "C:\Users\Arqam\Downloads\Drop down Specific Sheet Matheen.xlsm" just take the file path and file name and give your path and your file name between the quotes.

it will work.

Regards
Abdul Matheen

 

[paradise]

Well I have changed the code to

fileName = ThisWorkbook.FullName

This is nice too as I frequently changes the computer.But here it is working only in C3 & D3.But I want to get working in the C column i.e C4,C5,C6,....,etc and D column i.e D4,D5,D6,...etc..as a whole and not to specific cell C3 & D3.

Also is there is an alternative to VBA .

Hope this gets solved too.

With Best Rgds,
Suresh

 

[paradise]

Is there a same result without using VBA.

I will be very much thankful in this regard as I want too without the help of VBA.

I will be eagerly waiting for the reply form the forum contributors.

With Best Rgds,

suresh

 

[NARAYANK991]

Hi Suresh ,

If you are looking for a dynamic dependent DV , then this question has been asked and answered several times.

If it is a formula-based solution , I am not sure whether the cell in column B can be blanked if the selection in column A changes ; if this is acceptable , and if the list of jobs will always be sorted in order of the party , then see this file.

Narayan

 

[paradise]

Thanx greatly.Now this has been solved