Require VBA Code for filter Data after criteria match

[amartakale]

Dear Sir,

Can you help me below issue for VBA coding

This our portfolio company. I put simple one of VBA code for sector sorting & its work proper.

Now I required VBA code for below process

Portfolio Upgrade & Downgrade

1. When I select Year or month (Cell F4) & then Click “Portfolio Top 10 Upgrade FY20E” Button Then Data sort on “column AS” & Show Top 10 upgrade stocks
2. When I select Year or month (Cell F4) & then Click “Portfolio Top 10 Downgrade FY20E” Button Then Data sort on “column AS” & Show Top 10 Downgrade stocks
3. Same process for FY21E & other month also

Sector Portfolio Upgrade & Downgrade

1. When I select Year or month (Cell F4) & Select sector (Cell D4) & then Click “Sector Top 10 Upgrade FY20E” Then Data sort on “column AS” & Show Top 10 upgrade stocks in that specific sector with date criteria match.
2. When I select Year or month (Cell F4) & Select sector (Cell D4) & then Click “Sector Top 10 Downgrade FY20E” Then Data sort on “column AS” & Show Top 10 Downgrade stocks in that specific sector with date criteria match.
3. Same process for FY21E & other month also

Note: Can you see Why message show Be careful after save file. I am confused why it show.

Regards
Amar TakaleMonthly Estimates EPS.xlsm

[p45cal]

I think your shopping list needs to be tackled by someone you pay.

[amartakale]

Thanks for Reply.

I will try to solve this issue with formulas by myside. This group always helpful for me to learn something new ideas & trick & VBA.

Thanks one again

[Paul_Hossler]

Note: Can you see Why message show Be careful after save file. I am confused why it show.

That's from the Document Inspector warning you that there may be information in the file that might be sensitive

Capture.JPG


You can get more details from the Info screen



Capture2.JPG

Capture3.JPG

[amartakale]

Good Morning Paul Sir,
Thanks for reply. I got already this answer after some attempt in excel setting
"Options > Trust Center > Trust Center Settings > Privacy Options > then un-check the check box "

[amartakale]

Dear Pual & p45cal Sir,

Finally I done this task with help of google & use VBA also.I tried a lot of work & time in this task because p45cal sir give me challenge. And I want to share this sheet with you & Pual sir also our group (Sample sheet)

Now I can sort data Asc & Des within sector. Also sort data within in scheme. Also within Scheme & Sector at one time. I will sort all data asc & des & will saw upgrade & downgrade whole data of each month.This work is small different which I explain in previous mail but work fine for me.Monthly Upgrade & Downgrade.xlsm


Thanks & regards
Amar