Sorry - slight amendment - my macro deletes all later versions keeping the oldest - so ideally i need to either copy all data on the row other than timestamp from the latest version to the oldest or need to amend the macro i have to keep only the latest version rather than the oldest (later versions will allways be lower down on the list)