PDA

View Full Version : Require VBA Code for filter Data after criteria match



amartakale
10-16-2019, 06:54 AM
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


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
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
Same process for FY21E & other month also


Sector Portfolio Upgrade & Downgrade


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

p45cal
10-16-2019, 07:08 AM
I think your shopping list needs to be tackled by someone you pay.

amartakale
10-16-2019, 08:53 PM
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
10-17-2019, 01:29 PM
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

25302


You can get more details from the Info screen



25303

25304

amartakale
10-17-2019, 10:32 PM
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
11-27-2019, 06:43 AM
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.25495


Thanks & regards
Amar