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.
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.