Hi,

I need some excel help...

I am creating a weekly report where by i copy and paste information from a auto-generated report into a conditioned report. One of the things the conditioned report does is flags up an item when it has gone past it's valid to date (Cell D) when this happens a marker comes up in Cell H with a destruction date which is 28 days from when the report is run.

However, all these same items will be on next weeks report and if I copy and paste them again, the destruction date will change to 28 days from the date I do them next week but I need this to not happen. I.e. If an item says the destruction date is 26/06/13 then next week when I run the report I need this same item to still have the destruction date of 26/06/13 not the 03/07/13.

Any help would be brilliant?