m_vishal_c
Board Regular
- Joined
- Dec 7, 2016
- Messages
- 209
- Office Version
- 365
- 2016
- Platform
- Windows
HI, i need to filter particular / specific word in particular column like("A column") and select all(Filtered data), cut and paste , create another sheet in same workbook and paste into it.
for example
Need to filter "MPS" in code column and move those filtered in another sheet by creating new sheet
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
heaps thanks in advance
thanks
for example
Need to filter "MPS" in code column and move those filtered in another sheet by creating new sheet
code | address | Part |
PIT-000000013000835326 | 1 | 1 |
TAP-000000012502567470 | 1 | 1 |
2FRE-65-00-MPS-020 | 1 | 1 |
ALF-00000001250258666 | 1 | 1 |
ALF-000000012502612937 | 1 | 1 |
2FRE-65-00-MPS-031|2FRE-65 | 1 | 1 |
ALF-000000012502621977 | 1 | 1 |
TAP-00000001500557215 | 1 | 1 |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
heaps thanks in advance
thanks