Hi All!
I'm an envious excel learner, hoping to learn from a tricky problem I want to solve.
I want to be able to filter (table 1) based on a double click in a cell (table 2) that has a function that references the columns in (table 1).
This way when I am looking at table 2 I can double click the cell C3 on table2 and it will filter table 1 down to local 1, error1. Can this be done? Thank you all so much in advance, I'm really excited to learn this VBA myself!
I'm an envious excel learner, hoping to learn from a tricky problem I want to solve.
I want to be able to filter (table 1) based on a double click in a cell (table 2) that has a function that references the columns in (table 1).
This way when I am looking at table 2 I can double click the cell C3 on table2 and it will filter table 1 down to local 1, error1. Can this be done? Thank you all so much in advance, I'm really excited to learn this VBA myself!
| Sample.xlsx | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | |||
| 1 | Local | Error Count | error1 | error2 | error3 | error4 | error5 | error6 | error7 | ||
| 2 | 1 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | ||
| 3 | 2 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | ||
| 4 | 3 | 2 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | ||
| 5 | 4 | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | ||
| 6 | 5 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ||
| 7 | Total | 9 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | ||
Worksheet 2 | |||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| B2:B6 | B2 | =COUNTIF('Worksheet 1'!A:A,[@Local]) |
| C2:I6 | C2 | =COUNTIFS(Table1[[#All],[local]],[@Local],Table1[[#All],[Error]],C$1) |
| B7 | B7 | =SUBTOTAL(109,[Error Count]) |
| C7 | C7 | =SUBTOTAL(109,[error1]) |
| D7 | D7 | =SUBTOTAL(109,[error2]) |
| E7 | E7 | =SUBTOTAL(109,[error3]) |
| F7 | F7 | =SUBTOTAL(109,[error4]) |
| G7 | G7 | =SUBTOTAL(109,[error5]) |
| H7 | H7 | =SUBTOTAL(109,[error6]) |
| I7 | I7 | =SUBTOTAL(109,[error7]) |
