If cell contains a number copy/paste macro

[ScabbyDog]

I have the following which checks to see if a number is in column A and if it is copy and paste it. I want to alter it so that if it finds the number in say, A5 it pastes the value in B5. Or if it finds it in A20 then it pastes it in B20. Also, I want it to not only copy and paste if it finds a number on its own within a cell, but also copy and paste for example A12 if A12 is "Text 12 Test" then B12 would be Text 12 Test"

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

[hafizimran]

Please Login or Register  to view this content.

[ScabbyDog]

Thanks hafir. Works perfectly.