I have many fields on a SharePoint list and would like to have all of them copied to a new list whenever a copy is required. The difference is that I would like all items copied as they are with a new field updated with the datestamp.
Therefore each time copies are taken, they add to the second list with a new date. They do not overwrite the existing items on the second list, mere copy all list 1 items again with a new date stamp. This would also mean it keeps the 'modified' and 'modified by' on the new list, but this is really a secondary requirement and presumably could be done with new static field names?
Any help much appreciated.