N
Nik
Hi
I am looking for VB codes to copy rows based on partial cell content.
I have a spreadsheet called "main.xls" from which I would like to copy data
to another spreadsheet when certain crietria are met.
Column I have following data.
TML123
TML702
TML4568
TML956
FTF987
FTF0956
FTF687
TML257
I would like the macro to copy rows that have TML prefix to another workbook
(After.xls) and paste under a tab named TML. The macro should also copy rows
that have FTF prefix to the same workbook (After.xls) and paste under a tab
named FTF.
Thanks
I am looking for VB codes to copy rows based on partial cell content.
I have a spreadsheet called "main.xls" from which I would like to copy data
to another spreadsheet when certain crietria are met.
Column I have following data.
TML123
TML702
TML4568
TML956
FTF987
FTF0956
FTF687
TML257
I would like the macro to copy rows that have TML prefix to another workbook
(After.xls) and paste under a tab named TML. The macro should also copy rows
that have FTF prefix to the same workbook (After.xls) and paste under a tab
named FTF.
Thanks