I have cells that contain account numbers in column A and strings that contain text and account numbers in column B.
I would like to create a list of accounts and then check if any of those accounts is contained in column B. If it is I want to extract this account number to column C (in the same row it was found). I am a VBA noob so I'm not sure how this could be done.
I asked a similar but much more complex question earlier this week, but this should be easier to "solve".
[This is how I would like it to look like after processing]
There might be other numbers with the same length as the account numbers in column B that are NOT account numbers, so this excludes some solutions.