Create Calendar Wit Data Auto Fill using Excel 2000!

Hello,

I would like to create a calendar that I choose the month, data that auto
fills for one month begining with the first work day, and I choose the
holidays to skip when data is auto filling.

This is what I would like to do:
1) Have a data spread sheet where I add my data that will be added to the
cells in the calendar.
2) Have another spread sheet for calendar settings where I choose Holidays
and months are listed.
3) Have a spread sheet with the calendar displaying my data and being able
to change the data.

I need this calendar to add predetermined data to certain days of the month
skipping holidays & weekends, finding the first workday of the month.

Thank you for yur helpin advance,
James Cooper

Hello,

I would like to add some details to my previous post.

My calendar needs to be created in a excel 2000 spread sheet:
1. Select the month
2. Select the year

Then I will choose North Zone or South Zone each will have 40 building
names in three catagories Quarterly, Monthly, and BI-Weekly.

I would like for 6 buildings to auto fill per workday Monday-Friday for
one month.
Also I would like to have cetain Holidays of my choosing to be pre
filled with Holiday.
Lastly, I would like to print the calendar in black & White.

If more details are needed please ask!

Thank you for your help in advance
James Cooper

James Cooper wrote:
> Hello,
>
> I would like to create a calendar that I choose the month, data that auto
> fills for one month begining with the first work day, and I choose the
> holidays to skip when data is auto filling.
>
> This is what I would like to do:
> 1) Have a data spread sheet where I add my data that will be added to the
> cells in the calendar.
> 2) Have another spread sheet for calendar settings where I choose Holidays
> and months are listed.
> 3) Have a spread sheet with the calendar displaying my data and being able
> to change the data.
>
> I need this calendar to add predetermined data to certain days of the month
> skipping holidays & weekends, finding the first workday of the month.
>
> Thank you for yur helpin advance,
> James Cooper