Hello,

In column A of my spreadsheet I have a following data. I'm looking to copy just the cells that contain (DLR A/C: xxxxxxx). To make things more complicated, I just need the VBA macro to copy what follows the DLR A/C: part (what's bolded). It also doesn't help that there's about 6 spaces between each account information. I need the data to be pasted on another tab/workbook without the spaces in between each account information.

Account Number
5435234543
(DLR A/C: 432434432)



Account Number
454543534
(DLR A/C: MPR434432)



Account Number
454543534
(DLR A/C: 87868675)

First time poster and new member. Please let me know if I need to go about this request differently.

Much Appreciated!