Hi Colin,
Very sorry for the delayed reply, University has taken over the last few months! As such, in the end I gave up with the CSV file when I realised the dates were going into my Calendar wrong due to the US date display.
However I must stress that your replies have not been in vein! The information, especially for locking cell references has helped me further develop some other spreadsheets including ones used for my business so I am extremely grateful for that.
Sorry once again and thank you for your time,
Karl
P.S. - Rep left