PDA

View Full Version : Need help altering Planner VBA



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

Toonies
09-08-2011, 12:00 PM
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