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
contionious
b) I'd like values in certain columns to be reset
Thanks
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
contionious
b) I'd like values in certain columns to be reset
Thanks