Toonies
09-06-2011, 11:43 AM
Hi and thanks for looking
What I am looking for is to alter the following Planner from a 1 sheet covering 12 month planner in excel 2010 which works 100%
to a 2 sheet (each covering 6 months) Planner in Excel 2003
It has 2 Forms
one is to input
Name
Type of Leave being requested (choice of 3)
Start date
End date
the 2nd Form totals all the leave type by person
Now it works great in Excel 2010 which can accomodate the number of coloumns for the full year.
Since excel 2003 has only 256 columns that is why I need it to be split between 2 sheets
January-June
July-December
I am looking for the 1st Form to input data over the 2 sheets and the 2nd to collate and total over the 2 sheets for the full 12 month period.
I have attached a copy of the file which works on VBA
Many thanks
What I am looking for is to alter the following Planner from a 1 sheet covering 12 month planner in excel 2010 which works 100%
to a 2 sheet (each covering 6 months) Planner in Excel 2003
It has 2 Forms
one is to input
Name
Type of Leave being requested (choice of 3)
Start date
End date
the 2nd Form totals all the leave type by person
Now it works great in Excel 2010 which can accomodate the number of coloumns for the full year.
Since excel 2003 has only 256 columns that is why I need it to be split between 2 sheets
January-June
July-December
I am looking for the 1st Form to input data over the 2 sheets and the 2nd to collate and total over the 2 sheets for the full 12 month period.
I have attached a copy of the file which works on VBA
Many thanks