On 03/11/2010 19:21, Rob Clement wrote:
On 03/11/2010 12:55, Amichai Rotman wrote:
Hi All,
Continuing my last question:
I'd like to create a Sheet for each month. In column A of each sheet I'd
like to automatically generate the specific month's dates:
Is there a wizard I can use to specify the dates range (say: Nov 2010
till
December 2010) and it will create a Sheet for each month with the dates
automatically entered in column A - from A2 to A31 (or 30, if that
moth is
shorter).
Of course I want to use it on a different file for next year too....
I hope I was clear enough...
Thanks!
Amichai
I think the easiest way is this.
1) Create a start spreadsheet.
2) On the top line cell A1 type in the 1st date in the month e.g. 1/11/10
3) On the second line below the 1st date set a cell a2 with = a1 + 1.
The cell will show 2/11/10
4) Copy cell a2 downwards for as many days as you require and the dates
will appear.
5) In a new spreadsheet copy and paste the 31 days you require from the
first spreadsheet. Change the date at the top of the column to be
whatever start date you require and all the others will appear.
I hope that it clear
There's a 'Fill' entry on one of the menus too, which will handle dates.
But the OP wanted a new /sheet/ made automatically for each month. I'm
not sure there's a way of doing that (short of writing a macro).
--
Mike Scott
Harlow, Essex, England
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
