Hi
is there any formula to display only filtered units from one place to another place in the same workbook:
sheet1
sheet2
Sheet 1 is list with filter, when filter applied I want to display filtered rows to sheet 2
I need automatic formula .. each time I select different filter, it should display filtered rows
Also asked here Display only filtered values from sheet 1 to sheet 2 (text and numbers)
is there any formula to display only filtered units from one place to another place in the same workbook:
sheet1
| Book1.xlsx | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | I | J | K | L | M | |||
| 1 | name | number | ap | date | date | sum1 | sum2 | sum3 | sum4 | sum5 | sum6 | sum7 | ||
| 2 | Paradise | 2 | A2 | 07.11 | 08.11 | 60,75 € | - € | 60,75 € | 42,84 € | - € | 4,23 € | - 4,23 € | ||
| 3 | Paradise | 2 | A1 | 31.12 | 02.01 | 71,29 € | 71,29 € | - € | 60,00 € | 11,29 € | - € | - € | ||
| 4 | Big Blue | 2 | A1 | 31.12 | 02.01 | 127,50 € | - € | - € | - € | |||||
| 5 | Big Blue | 3 | A1 | 16.03 | 20.03 | 366,66 € | 366,66 € | - € | 291,67 € | 74,99 € | - € | - € | ||
| 6 | Dammi | 9 | A1 | 26.03 | 28.03 | 230,40 € | 193,31 € | - € | 156,44 € | - € | 14,10 € | - 14,10 € | ||
| 7 | Paradise | 2 | A2 | 27.03 | 05.04 | 733,32 € | - € | 733,32 € | 633,32 € | - € | 100,00 € | -100,00 € | ||
| 8 | Big Blue | 4 | A1 | 09.04 | 11.04 | 189,00 € | 183,33 € | - € | 141,84 € | 41,49 € | - € | - € | ||
| 9 | Dammi | 2 | A2 | 10.04 | 11.04 | 45,50 € | 38,17 € | - € | 30,84 € | - € | - € | - € | ||
| 10 | Big Blue | 2 | A1 | 11.04 | 18.04 | 735,00 € | 712,95 € | - € | 592,01 € | 120,94 € | - € | - € | ||
Sheet1 | ||||||||||||||
sheet2
| Book1.xlsx | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | I | J | K | L | M | |||
| 3 | Paradise | 2 | A2 | 07.11 | 08.11 | 60,75 € | - € | 60,75 € | 42,84 € | - € | 4,23 € | - 4,23 € | ||
| 4 | Paradise | 2 | A1 | 31.12 | 02.01 | 71,29 € | 71,29 € | - € | 60,00 € | 11,29 € | - € | - € | ||
| 5 | Paradise | 2 | A2 | 27.03 | 05.04 | 733,32 € | - € | 733,32 € | 633,32 € | - € | 100,00 € | -100,00 € | ||
Sheet2 | ||||||||||||||
Sheet 1 is list with filter, when filter applied I want to display filtered rows to sheet 2
I need automatic formula .. each time I select different filter, it should display filtered rows
Also asked here Display only filtered values from sheet 1 to sheet 2 (text and numbers)
Attachments
Last edited by a moderator:
