Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add data to calendar from worksheet, Excel 2000-2003
Hello,
I have a calendar that I select the month from a drop down and it will create a calendar. I would like to put a list of data in column a begining in cell 1 and a list of dates in column b begining in cell 1 each on sheet2. Then I'll need the data when the month is selected in column a the macro will put that data in the calendar on sheet 1 according to the dates in sheet 2 column b. I have not found a calendar to work excatly the I need it to so all help will appreciated. Sheet2 Data: COLUMN A COLUMN B 1 HOME 1/3/2006 2 WORK 1/4/2006 3 MEETING 1/6/2006 4 PARTS 2/4/2006 5 ORDERS 3/20/2006 Thank you for your help' jfcby |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calendar DropDown & Scrollbar HELP, Excel 2000-2003 | Excel Programming | |||
Calendar change month from multiple sheets to one sheet, Excel 2000 & 2003 | Excel Programming | |||
Create Calendar Wit Data Auto Fill using Excel 2000! | Excel Programming | |||
Calendar Control in Excel 2000 can't display date in Excel 2003? | Excel Discussion (Misc queries) | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel |