Hi thanks,

I have a list of Order Numbers in column A

BDG-00000001
BDG-00000002
BDG-00000003

When i press the button, I would like it to simply add the following to the ID numbers in coulmn B as a seperate list or even alter column A.

'BDG-00000001',
'BDG-00000002',
'BDG-00000003',

I have achieved this by recording a macro however the list of ID numbners that will be in the spreadsheet will very, e.g. today there are 50 but tomorrow there could be 100

Can you alter my original marco so that the script is not fixed to Range("B2:B53") as shown in my example, and it will apply this formula to all cells in the column

Hope this makes sense,

cheers,

Dave