| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy entire row(s) to another workbook based on partial cell crite
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Entire Row based on Cell Value | Excel Programming | |||
| copy workbook to new workbook based on cell value | Excel Programming | |||
| Copy an entire row based on value in one cell | Excel Programming | |||
| Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet. | Excel Programming | |||
| sum if based on PARTIAL content of another cell | Excel Worksheet Functions | |||
Threaded Mode
