Data Validation from another Sheet

[coolkiran]

Hello All

I have a requirement which i am doing in VBA. I have sheet called Drop downs, where i have 5 columns, Sheetname, Catergory, Column name, Sub category, Column Name.

Now, macro has to go Drop down sheet, and filter each sheet name, eg : if sheet name KPI1, then it has to copy all category and paste in KPI 1 Column (which is in Column name next to Category) as drop down (Data validation) for 100 rows.

Based on Category , it has to give sub category (Column name is in Drop down sheet next to Sub Cateogory).

Any suggestion would be great.

I have attached sample file.

 

[coolkiran]

Any Suggestion would be appreciated...

 

[charlesdh]

Hi,
Hope this helps. Click the Run button.

 

[coolkiran]

Hi,
Hope this helps. Click the Run button.

Thanks Charlesdh.

Unfortunately i need data validation for that. The file you sent will do filter and paste to respective sheet and column.

 

[charlesdh]

coolkiran,
Sorry, but I do not fully understand your requirements
Are you wanting a "Data Drop down" in the "DataDropdown" sheet and have the "Filtered Data" sent to the associated worksheet?

Check this site to see it will help you.
https://www.extendoffice.com/documents/excel/4586-excel-filter-data-from-drop-down-list.html