So I am new to the forums and have not used excel/vba in many years. I am currently using excel 2000 and wish to create a calendar schedule.

on one sheet i will have columns:

company
po
item
due date
run date

on another sheet i was looking to get a calendar that will auto fill based on selected month and year.
i was wondering if anyone knew how to fill in a calender with the po and item on the corresponding scheduled run date.

i have seen some similar things to this but they don't seem to function properly in excel 2000. if you need more information i can try to get into more detail.

thank you