Hi
New here and seem to have hit a brick wall so back to the board.
I have tried amending some previous code to give me a different output. Seemed simple enough but I am not getting the desired output and I'm also not sure it's the most efficient method.
Basically I have two columns and all I am trying to do is copy any matching/duplicate names in both columns to a new column J. Column I is simply numbered 1,2,3, etc and is dynamically generated.
The number of candidates in both columns can of course change and is not fixed.
I've attached my file and would appreciate any help. I can do it in Excel but would like a Excel VBA script to do it.
Many thanks in advance.
Reply With Quote