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