Claire_Brummell
Board Regular
- Joined
- Sep 29, 2004
- Messages
- 129
Hi,
I'm trying to use VBA to create a 'calendar' style report.
Basically when you run the code to create the calendar it asks the user to enter a start and end date which it will then collate the information for. The information rather than being stored to a specific date, is linked to a month and year - so the date an item could be linked to would be Oct-2006 or Feb-2007 (though these are stored as full dates in the sheet - appearing as 01/12/2006 or 01/02/2007).
When I create the new sheet (which will house the calendar) I want it to create the calendar headings in the 3rd row starting at the second column, for the range of dates that the user has input.
So for example if the start date was 01/01/06 and the end date was 01/10/07, I want cell B3 to be "Jan-2006", C3 to be "Feb-2006", D3 to be "Mar-2006" right the way through to "Oct-2007". I'd like the values to be 01/01/06, 01/02/06 up to 01/10/07 and then change the format of the row to be "mmm-yyyy" so that I can use them for calculations if necessary.
Can anyone help?
I'm trying to use VBA to create a 'calendar' style report.
Basically when you run the code to create the calendar it asks the user to enter a start and end date which it will then collate the information for. The information rather than being stored to a specific date, is linked to a month and year - so the date an item could be linked to would be Oct-2006 or Feb-2007 (though these are stored as full dates in the sheet - appearing as 01/12/2006 or 01/02/2007).
When I create the new sheet (which will house the calendar) I want it to create the calendar headings in the 3rd row starting at the second column, for the range of dates that the user has input.
So for example if the start date was 01/01/06 and the end date was 01/10/07, I want cell B3 to be "Jan-2006", C3 to be "Feb-2006", D3 to be "Mar-2006" right the way through to "Oct-2007". I'd like the values to be 01/01/06, 01/02/06 up to 01/10/07 and then change the format of the row to be "mmm-yyyy" so that I can use them for calculations if necessary.
Can anyone help?