nikhil0311
Board Regular
- Joined
- May 3, 2013
- Messages
- 197
- Office Version
- 2013
- Platform
- Windows
I have an excel sheet with below columns and data.
Now from the above data, i want to see data for Client 'Abc Inc' ONLY. So, I will put filter on Column A5 and select the client from Column A5 and then paste the visible data to new worksheet. see below for the output.
similarly if i want to see data for Group - Energy, then i will go to column E5, select energy and copy paste the visible data to new worksheet
basically i want to create 5 button so the user can select the criteria based on below
Button1 - Client - when click on this button, one should be able to see all the client list and then select any of the client/clients. similarly for Banker, Group, Event button mentioned below
Button2 - Banker
Button3 - Group
Button4 - Event
and then when one click on 5th button i.e. Generate one should get the output based on the above filters in the new worksheet.
Let me know if you have any doubts?
Excel 2007 | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||
1 | Client Event Tracking | |||||||||||||||
2 | ||||||||||||||||
3 | Date | Aug-15 | Jul-15 | Jan-15 | Jul-14 | |||||||||||
4 | New Event | Pebble Beach | US Open | Leadership | US Open | |||||||||||
5 | Client Name | CASID | Banker | Banker Email | Group | Executive Title | Executive Actual Title | Executive Name | ||||||||
6 | Abc Inc | 123 | Dan, H | Energy | CEO | Accepted | Yes | |||||||||
7 | Xyz LLC | 231 | Sam, K | Northeast | CFO | No | Postpone | |||||||||
8 | PQR Ltd | 876 | Nik, K | Midwest | Treasurer | Yes | ||||||||||
9 | BBQ Equity | 435 | Sank, M | Energy | Other | Maybe | ||||||||||
10 | Dominos Inc | 232 | Dee, G | Technology | CEO | Check | Change | |||||||||
Output |
Now from the above data, i want to see data for Client 'Abc Inc' ONLY. So, I will put filter on Column A5 and select the client from Column A5 and then paste the visible data to new worksheet. see below for the output.
Excel 2007 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | Client Event Tracking | ||||||||||||
2 | |||||||||||||
3 | Date | Aug-15 | |||||||||||
4 | 3 | 2 | 1 | New Event | Pebble Beach | ||||||||
5 | Client Name | CASID | Banker | Banker Email | Group | Executive Title | Executive Actual Title | Executive Name | |||||
6 | Abc Inc | 123 | Dan, H | Energy | CEO | Accepted | |||||||
Sheet1 |
similarly if i want to see data for Group - Energy, then i will go to column E5, select energy and copy paste the visible data to new worksheet
basically i want to create 5 button so the user can select the criteria based on below
Button1 - Client - when click on this button, one should be able to see all the client list and then select any of the client/clients. similarly for Banker, Group, Event button mentioned below
Button2 - Banker
Button3 - Group
Button4 - Event
and then when one click on 5th button i.e. Generate one should get the output based on the above filters in the new worksheet.
Let me know if you have any doubts?
Last edited: