Hi Alansidman

Thanks for the help, much appreciated. For some unknown reason , I cannot upload my sample data. I select manage attachments> add files> Browse to select the workbook> upload data, but the files are not uploaded. It may have to do with a setting on my PC. It would be appreciated if you can assist

The macro is copying the numeric data from Col K to Col J but after the last item in Col J. What I want the macro to do, is that where there is a number value for eg 2507K in K5 then thismust be copied to J5 etc

Your assistance in this regard is most appreciated