Would the column already exist?, how would you decide which person gets which locality code?, is there a seperate sheet for each locality code?
Why would you need to copy and paste? from what i see in your example you simple need =Original!D1 in all your blank cells in the locality column or if only using the original sheet then use =D1 and copy down.
If this doesn't suffice then you need to provide a sample workbook which is truly representative in data type and structure to your live workbook so we can help further.
Bookmarks