+ Reply to Thread
Results 1 to 4 of 4

How to add a Recurring event to an Appointment Calendar

  1. #1
    Registered User
    Join Date
    02-24-2021
    Location
    Ottawa, Canada
    MS-Off Ver
    2010
    Posts
    13

    How to add a Recurring event to an Appointment Calendar

    Hello All,
    I am working with the Appointment Scheduler that is below and it is almost everything I need.
    What I need to add is:
    1) a drop down menu of Client Names to enter into the time slots that appear under the staff name. The names would come from a separate sheet that has several columns of info for each client
    2) I need to add a separate column beside the staff column with the appointment times under it. In this new column would be a recurring interval ie. 7 Days, 14 Days, 21 Days, 28 Days or 30 Days (once a month). Once either 7, 14, 21, 28 or 30 is entered in this column next to the clients name at a specific time period the future calendar would automatically be updated to show his future appointment.
    Any help here would be greatly appreciated.
    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,556

    Re: How to add a Recurring event to an Appointment Calendar

    As to the drop downs:
    1. Set up a range of data with staff in one column and clients in another as modeled on the Client sheet
    2. The source for the data validation is: =OFFSET(Clients!A$1,MATCH(M$2,Clients!A$2:A$21,0),1,SUMPRODUCT(--(Clients!A$2:A$21=M$2)))
    Note that changing the staff name in cell M2 changes the choices but not the clients that are already displayed.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    02-24-2021
    Location
    Ottawa, Canada
    MS-Off Ver
    2010
    Posts
    13

    Re: How to add a Recurring event to an Appointment Calendar

    Thanks JeteMc,
    I have posted an update to this post yesterday. I was finally able to complete part 1. My biggest problem is with Part 2, the recurring appointment. This has been exceptionally
    difficult for me. I just have no clue how to do it.

    I have attached an up dated file below.
    Thanks for any help. Very much appreciated.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    02-24-2021
    Location
    Ottawa, Canada
    MS-Off Ver
    2010
    Posts
    13

    Re: How to add a Recurring event to an Appointment Calendar

    Hello JeteMc,

    I like your client drop down list a lot better than mine. On mine when I change staff the appointments disappear.

    Thanks again.

    Regards,
    WillMa

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Appointment Calendar with Recurring appointments
    By WillMa in forum Excel General
    Replies: 0
    Last Post: 03-04-2021, 03:45 PM
  2. Set appointment in someone else's outlook calendar
    By go3go3go in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2019, 04:47 PM
  3. Event calendar with recurring event
    By glnorton in forum Excel General
    Replies: 2
    Last Post: 11-05-2014, 04:42 PM
  4. Event Calendar - Recurring event and filter
    By glnorton in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-01-2014, 07:57 PM
  5. VBA Recurring Calendar Appointment In Other Users Calendar
    By hobbiton73 in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 11-20-2013, 04:27 AM
  6. VBA Recurring Calendar Appointment
    By hobbiton73 in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 11-13-2013, 03:43 AM
  7. Creating an Appointment Calendar
    By vipjd39 in forum Excel General
    Replies: 3
    Last Post: 02-19-2009, 12:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1