Concatenate a calendar
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Concatenate a calendar

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Arizona
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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?

  2. #2
    New Member
    Join Date
    Feb 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com