I have posted in a existing thread at mrexcel as i believe my problem and possible solution is very similar to that already detailed there. However i have not recieved a response there yet and was looking to draw upon more minds here.

http://www.mrexcel.com/forum/showthread.php?t=294116

My problem is that every month i recieve data for various postcodes. The spreadsheet as such:

Col A....Col B....Col C....Col D
123......6.........123......8
124......6.........125......8
125......7.........126......7
126......6.........127......6
127......7..etc

Previously i have manually inserted 2 cells in Col C & D until Col C matches up with the corresponding postcode (number) in Col A. Col B & D do not have to match, but are rather the actual data attributed to each postcode. Doing it manually is very time consuming and i am seeking an automated method.

Desired end result:

Col A....Col B....Col C....Col D
123......6.........123......8
124......6.....................
125......7.........125......8
126......6.........126......7
127......6.........127......6

(Col C & D have been moved down 1 cell each so that Col C matches the number in Col A)

Note: This is a monthly job that involves adding each new months data on the end. Doing it manually, i would hide previous months so i can more easily match up the postcodes visually. Not sure how this would affect any automated solution. Also as i mentioned in the post on the other forum, occasionally a new number will appear in Col C that does not exist in Col A. I imagine a manual approach will have to be taken here to rectify errors that occur as a result and enable the automation to continue.