Filtering in Corresponding Gross Value using VBA in Excel

akpflow

New Member
Joined
Aug 2, 2016
Messages
9
Good day... I'm new in this forum...
I have a spreadsheet that uses filter to narrow down my search/selection but the gross value doesn't change.
I would love an excel shhet that has the corresponding gross value as the filter changes.
I can send you a dummy file for clarity.


Best,
Akpflow
Filter 1Filter 2
Date
Filter 3
`Gross Pay

<tbody>
</tbody>
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

MUKESHY12390

Well-known Member
Joined
Sep 18, 2012
Messages
899
Office Version
  1. 2013
  2. 2011
  3. 2010
  4. 2007
Platform
  1. Windows
just upload couple of records form sample data and it would help to find out better solution.
 
Last edited:

akpflow

New Member
Joined
Aug 2, 2016
Messages
9
just upload couple of records form sample data and it would help to find out better solution.

Thanks Mukeshy, let use this :
Player (Filter 1)
Game Type (Filter 2)
Match (Filter 3)
Bonus
Gross Bonus
Vardy
Champions LEague
Home
40
40
Huth
Carling Cup
Away
70
110
Fuchs
Champions League
Away
110
220
Vardy
EPL
Home
50
270
Fuchs
EPL
Home
50
320
Huth
Champions League
Home
150
470

<tbody>
</tbody>
In this table above, There are three filters (player, game type, match).. Gross Bonus is the cumulative sum of the individual player's bonuses. How can I ensure that if one, two or all filters are active, the gross bonus will response promptly for example, when the filter 1 selects only Vardy, The gross bonus is 90:
Player (Filter 1)
Game Type (Filter 2)
Match (Filter 3)
Bonus
Gross Bonus
Vardy
Champions LEague
Home
40
40
Vardy
EPL
Home
50
90

<tbody>
</tbody>
Example 2: When the filter 2 selects EPL,
Player (Filter 1)
Game Type (Filter 2)
Match (Filter 3)
Bonus
Gross Bonus

<tbody>
</tbody>
Vardy
EPL
Home
50
50
Fuchs
EPL
Home
50
100

<tbody>
</tbody>
How can I achieve this?
Thanks in advance...
 

Forum statistics

Threads
1,186,164
Messages
5,956,313
Members
438,246
Latest member
Deelea

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top