Concatenate a calendar

jeffmfrank · Mar 1st, 2002, 04:23 PM

I'm trying to create a calendar that uses a database type of list of events and concatenates a text string of 5 cells in one row associated with the event to drop the into the proper day in a calendar. I'd like the calendar to be in the same workbook. The challenge I face is getting multiple events entered into the list to automatically populate the calendar. A vlookup isn't any good because the dates in the list will not be in order and there will be multiple entries for single days. Any suggestions on how to approach?

Andy Gee · Mar 2nd, 2002, 03:56 AM

Maybe use validation ranges, indirect and offset. With more info I may be able to tell you more

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 1st, 2002, 04:23 PM	#1
jeffmfrank Board Regular Join Date: Feb 2002 Location: Arizona Posts: 72	I'm trying to create a calendar that uses a database type of list of events and concatenates a text string of 5 cells in one row associated with the event to drop the into the proper day in a calendar. I'd like the calendar to be in the same workbook. The challenge I face is getting multiple events entered into the list to automatically populate the calendar. A vlookup isn't any good because the dates in the list will not be in order and there will be multiple entries for single days. Any suggestions on how to approach?

Mar 2nd, 2002, 03:56 AM	#2
Andy Gee New Member Join Date: Feb 2002 Posts: 48	Maybe use validation ranges, indirect and offset. With more info I may be able to tell you more