Hello All,

I have a pretty large sheet to look into ("CellData"). I am looking in column B which has the following value pattern:

129(8769)

I would like a vba code to search based upon numbers in brackets i.e 8769 only and once it is found that row should be put in a new sheet.

Will appreciate any help in this regard.
Thank you for your help.
Saziz