Copy common number present in multiple rows

Hope this helps

Sometimes its best to start at the beginning and learn VBA & Excel.

Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me