Thanks for the reply, i should of probably explained myself a bit better.
So i essentially will have a copy of worksheet, though the values in this duplicate will have the cell value before a cell value is changed in the original worksheet.