some excel automation to my excel sheet

Job ID: 35906493

Budget: ₹600 – ₹650 INR

I have excel sheet
I need searchable 3 drop down list on EOD DYNAMIC DATA sheet in my excel
1-NIFTY 50 STOCKS
2-NIFTY 100 STOCKS
3-NIFTY 500 STOCKS

I have one EOD DYNAMIC DATA sheet in my excel I need automation where I have to pass this all nifty 50 or nifty 100 stocks one by one to cell F2 and if value of J11 = ENTRY OR EXIT then I have to copy row A11 to ANALYSIS sheet with single click all 50 or 100 stocks must pass to the cell and should get the value in ANALYSIS sheet as mentioned

I am attaching the excel file kindly check
Related categories: Visual Basic Data Processing Data Entry Excel