Hi,
I am struggling to find out a way through which i need to copy a range of data from say cell A1:A10 and paste these 10 rows of data in a filtered data set in such a way that all the 10 rows are pasted only the visible filtered cell.
For eg say i have 3 rows of Data A1:A3 (1;2;3)
I want to filter data on the basis of criteria "Punit" and the result to be is as shown below
I am struggling to find out a way through which i need to copy a range of data from say cell A1:A10 and paste these 10 rows of data in a filtered data set in such a way that all the 10 rows are pasted only the visible filtered cell.
For eg say i have 3 rows of Data A1:A3 (1;2;3)
I want to filter data on the basis of criteria "Punit" and the result to be is as shown below
| S6_Collections_With_IF_Start.xlsx | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | 1 | |||||
| 2 | 2 | |||||
| 3 | 3 | |||||
| 4 | ||||||
| 5 | ||||||
| 6 | Filter "Punit" | Data | ||||
| 7 | Punit | |||||
| 8 | Ayush | |||||
| 9 | Punit | |||||
| 10 | Ayush | |||||
| 11 | Punit | |||||
| 12 | ||||||
| 13 | ||||||
| 14 | Result required | Data | ||||
| 15 | 1 | |||||
| 16 | Ayush | |||||
| 17 | 2 | |||||
| 18 | Ayush | |||||
| 19 | 3 | |||||
Sheet1 | ||||||
