View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sal21[_35_] sal21[_35_] is offline
external usenet poster
 
Posts: 1
Default Mission Impossible


Naturally in the event open wbook

is possible to insert in the column K of this sheet the range of da
for not used this sheet (add this range of date not used to up o
existing date and not delete existing date).

Note: i have insert in autoclose of this sheet a comand to save i
always.

Example:

i open the sheet on 01/09/2004
i close in the same date (and autosave)

i reopen this after 12 day

when i open the sheet insert in the column K the step of date relativ
to not used this sheet with not deleted the exinsting date up from th
last util cell

in this case

02/09/2004
03/09/2004
04/09/2004
07/09/2004
08/09/2004
09/09/2004
10/09/2004
11/09/2004


consider:

without :Saturday Sunday

without :Cristmas, New Year's Day,

without : a range of date to refer the national italian holyday (refre
in another column of the sheet, this is a range free for inserting)

in effect refer to a complete calendar day with only a work day...


http://www.gssitaly.com/test.zip

I hope of to have been clea

--
sal2

-----------------------------------------------------------------------
sal21's Profile: http://www.excelforum.com/member.php...nfo&userid=204
View this thread: http://www.excelforum.com/showthread.php?threadid=26330