ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   find a replace (https://www.excelbanter.com/excel-programming/368612-find-replace.html)

[email protected]

find a replace
 
Hi,

I'm trying to write a macro in excel to find a predefined codes ina
sequence of codes in a single cell, if the any of the codes match the
predefined codes macro has to cut that particualr row and paste the
same in another spreadsheet.

Example :-

Loan# Exclude 1 Exclude 2
123465 LI,SA sa,li,3f
123466 dd sf,dd,ex,gh,LIP
123467 co cop
123468 aa sf,dd,ex,gh,LIP
123469 fdf sa,li,3f
123470 fdf cop
123471 df co
123472 dd aa
123473 dd fdf

if in first row 3f is the predefined code so it has to cut this
particular row and paste in another spreadsheet for further research.

please help me on this.



All times are GMT +1. The time now is 02:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com