Hi! this forum is helping me a lot when I can't find any solution in google
I would like to copy automatically only the filtered values in one column to another column in another sheet. Here is an example with filters in the column B.
The entire table
Thank you in advance
I would like to copy automatically only the filtered values in one column to another column in another sheet. Here is an example with filters in the column B.
EQ Utilization Report October W4 2021.xlsx | ||||||
---|---|---|---|---|---|---|
B | C | D | E | |||
3 | Numero | Longitud | Ancho | Peso | ||
4 | 1 | 0.37208 | 0.230338 | 0.763773 | ||
20 | 1 | 0.52705 | 0.302138 | 0.409055 | ||
25 | 1 | 0.736017 | 0.986531 | 0.487414 | ||
27 | 1 | 0.49086 | 0.209107 | 0.723877 | ||
28 | 1 | 0.579735 | 0.256359 | 0.099415 | ||
32 | 1 | 0.718727 | 0.189102 | 0.222802 | ||
Sheet3 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C4:E4,C20:E20,C25:E25,C27:E28,C32:E32 | C4 | =RAND() |
The entire table
Cell Formulas | ||
---|---|---|
Range | Formula | |
C4:E43 | C4 | =RAND() |
Thank you in advance