I have a worksheet in excel that I would like to have automatically add
a copy of itself to the workbook on Mondays or every 7 days from a
specified date.

I also want this sheet to automatically add the the dates of the week
to cells 'g8', 'k8','o8','s8','w8'. So that if Mon is 05-05-05 then it
will show in cell g8 and Tuesday would show 05-06-05 and so on.

Is this possible and if so what would the code be.


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=447740

See one answer at your previous post.

Please don't post the same question multiple times. It just tends to
fragment any answers you get, as well as potentially wasting the time of
those answering questions that have already been answered.

For tips on using these groups effectively, see

http://cpearson.com/excel/newposte.htm


In article ,
oberon.black
wrote:

I have a worksheet in excel that I would like to have automatically add
a copy of itself to the workbook on Mondays or every 7 days from a
specified date.

I also want this sheet to automatically add the the dates of the week
to cells 'g8', 'k8','o8','s8','w8'. So that if Mon is 05-05-05 then it
will show in cell g8 and Tuesday would show 05-06-05 and so on.

Is this possible and if so what would the code be.