Thank you very much Charlize,
I couldn't use the email part cause it saves the workbook to the c:/ drive and my company does not allow that
so i used Ron.

Just one more thing why do numbers appear on the Croydon Sheet
in Column I ?

Once again thank you for all your help Charlize

Reagrds

Nurofen

Thank you to others for time spent on helping