Hi I have a worksheet that I want to make an exact copy of (through VBA) except
a) in cell C5 there may be a date e.g. 29/04/02 - in cell F5 there is a formula saying C5 + 7 and so on for 13 weeks - so say the last date entry in AM5 says AJ5 +7 and the date is 22/07/02
I'd like the new worksheet to say in cell C5 29/07/02 and then in cell F5 it says C5 + 7 etc etc
basically the user can click insert new worksheet and it alters the dates to be
b) I'd like values in certain columns to be reset