+ Reply to Thread
Results 1 to 11 of 11

Formulas to Enter Events in Calendar Sheets

  1. #1
    Banned User!
    Join Date
    10-12-2018
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    358

    Formulas to Enter Events in Calendar Sheets

    Hello,

    Is it possible to have formulas to put the descriptions from the Events! sheet to the matching days in the calendars sheets? I put just a few examples of course there will be many more for the year.

    Thank you for any help,
    XJ

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    13,154

    Re: Formulas to Enter Events in Calendar Sheets

    Why not just use the macro for adding holidays & change the sheet name in the code to Events

  3. #3
    Banned User!
    Join Date
    10-12-2018
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    358

    Re: Formulas to Enter Events in Calendar Sheets

    Thank you for the reply but will that work?

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    13,154

    Re: Formulas to Enter Events in Calendar Sheets

    As long as the Event sheet & Holiday sheet are setup the same, then it should do.

  5. #5
    Banned User!
    Join Date
    10-12-2018
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    358

    Re: Formulas to Enter Events in Calendar Sheets

    I tried that but it replaces the Holiday if there is one there.

  6. #6
    Banned User!
    Join Date
    10-12-2018
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    358

    Re: Formulas to Enter Events in Calendar Sheets

    Maybe the code can be altered to incorporate both sheets (Holidays and Events)?

  7. #7
    Banned User!
    Join Date
    10-12-2018
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    358

    Re: Formulas to Enter Events in Calendar Sheets

    I tried an example see January 21.

  8. #8
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    13,154

    Re: Formulas to Enter Events in Calendar Sheets

    How about
    Please Login or Register  to view this content.
    Note the change in the Clearcells code

  9. #9
    Banned User!
    Join Date
    10-12-2018
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    358

    Re: Formulas to Enter Events in Calendar Sheets

    That works great thank you very much. I think this should cover the Holiday and up to 4 additional events for the same day.

    Just curious if I face a very busy day and need more what are my options?

  10. #10
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    13,154

    Re: Formulas to Enter Events in Calendar Sheets

    Cancel an appointment

    Either concatenate some of the events together in one cell, or increase the number of cells available.

  11. #11
    Banned User!
    Join Date
    10-12-2018
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    358

    Re: Formulas to Enter Events in Calendar Sheets

    Thank you Fluff I will make some notes for those ideas.

+ 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. Using Excel VBA to Add events into Google Calendar
    By AV114 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-22-2018, 06:10 AM
  2. Excel Calendar to track events
    By X82 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-28-2018, 09:09 PM
  3. populate events calendar from inputs
    By excelforum2k16 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-31-2016, 03:44 AM
  4. Formula for Calendar with reoccuring events
    By jnm014 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-16-2015, 10:59 AM
  5. Repeat Events Calendar
    By zplugger in forum Excel General
    Replies: 6
    Last Post: 12-23-2014, 12:27 PM
  6. How to enter rows of data accross multiple sheets and keep the formulas intact?
    By Djbuff44 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-10-2014, 05:32 PM
  7. Populating a calendar with list of events
    By bwells3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2011, 05:31 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