mostafanabilemostafa
New Member
- Joined
- Feb 11, 2021
- Messages
- 7
- Office Version
- 2016
- Platform
- Windows
Dear All:
I'm working on a project and I need your help
I need Vba code to Auto filter and count items based on multiple columns based on uploaded dynamic dara from another sheet
For example I have
![enter image description here enter image description here](/board/proxy.php?image=https%3A%2F%2Fi.stack.imgur.com%2FKAcYE.png&hash=f53d08f269360e9fdb402b5de6b0ec44)
So the result should be
![enter image description here enter image description here](/board/proxy.php?image=https%3A%2F%2Fi.stack.imgur.com%2FW7qMU.png&hash=70fd15851d24dd568cac45ca8eedabea)
And so on for all the range
I tried Auto filter then select case code for the filltered data And worked but only for another view not the one I'm looking for And the resulted from select case was as below
![enter image description here enter image description here](/board/proxy.php?image=https%3A%2F%2Fi.stack.imgur.com%2FcK51m.png&hash=e2b43b956774ba93b2abad1ab388229b)
Appreciate your support please to get the filtered data as this mode
![enter image description here enter image description here](/board/proxy.php?image=https%3A%2F%2Fi.stack.imgur.com%2FabZe4.png&hash=d738edb82fdfff3bdaf1eafc666af6b5)
excel
I'm working on a project and I need your help
I need Vba code to Auto filter and count items based on multiple columns based on uploaded dynamic dara from another sheet
For example I have
![enter image description here enter image description here](/board/proxy.php?image=https%3A%2F%2Fi.stack.imgur.com%2FKAcYE.png&hash=f53d08f269360e9fdb402b5de6b0ec44)
So the result should be
![enter image description here enter image description here](/board/proxy.php?image=https%3A%2F%2Fi.stack.imgur.com%2FW7qMU.png&hash=70fd15851d24dd568cac45ca8eedabea)
And so on for all the range
I tried Auto filter then select case code for the filltered data And worked but only for another view not the one I'm looking for And the resulted from select case was as below
![enter image description here enter image description here](/board/proxy.php?image=https%3A%2F%2Fi.stack.imgur.com%2FcK51m.png&hash=e2b43b956774ba93b2abad1ab388229b)
Appreciate your support please to get the filtered data as this mode
![enter image description here enter image description here](/board/proxy.php?image=https%3A%2F%2Fi.stack.imgur.com%2FabZe4.png&hash=d738edb82fdfff3bdaf1eafc666af6b5)
excel