I have been trying to automatically insert the date in collumn B, when something is entered in collumn A. (Collumn is a drop-down menu, but I wouldn't have thought this would affect anything). I tried to investigate this on the website, and managed to find a solution (http://www.mrexcel.com/archive/Dates/29888.html). It was all working fine, but then I just formatted the spreadsheet and did a couple of things to it, and when I re-opened the spreadsheet to use it, the date/time was not entered. The coding still appeared to be correct. To investigate the problem, I tried to insert a new sheet in the workbook, and in the second sheet, the coding would not work, so I must have made a change to the workbook, rather than just the sheet (the coding works when I create a new workbook). Does anyone have any ideas as to what I may have done to stop it working? Or how to clone the contents of the sheet so I can try again? Or just any other suggestions? Thanks!