-
Need help altering Planner VBA
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
-
Hi file has been converted to 2003 (many thanks to xld and all others)
The Forms work separately on each individual sheet
just wondering if anyone knows how to link them to work on each sheet
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules