Hi,
Yes, it is the same lay out.
I don't know how to determine the bit for working out the last time it was run... I was thinking maybe a lookup to see if the ref number in column A had already been copied over? Or even to just copy everything over and re-write what is already there each time if...