+ Reply to Thread
Results 1 to 4 of 4

Auto Populating calendar that changes all data with each month.

  1. #1
    Registered User
    Join Date
    08-23-2017
    Location
    Northwest Territories, Canada
    MS-Off Ver
    MS Office 2013
    Posts
    6

    Auto Populating calendar that changes all data with each month.

    Hello friendly excel experts,

    I have two auto populated calendars that I'm trying to get all the data in them to change each time I change the month. The calendars are used for two different campsite locations to show my staff when visitors are booked in. I've attached the spreadsheet.
    If someone can help me or give me instructions on how to make this happen that would be wonderful.
    Thank you!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Re: Auto Populating calendar that changes all data with each month.

    hey there,

    your file and the description do not truly get the task across I'm afraid. If you still need help with this task, please either try to describe in more detail what needs to be done or hit me up via PM and I'm sure we can get this done.

    Best
    B
    If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.

  3. #3
    Registered User
    Join Date
    08-23-2017
    Location
    Northwest Territories, Canada
    MS-Off Ver
    MS Office 2013
    Posts
    6

    Re: Auto Populating calendar that changes all data with each month.

    Hi B,

    Thanks for your response and follow up question. I will try my best to explain to you what I'm looking to do.

    In the sheets labelled VF-Calendar and RKL-Calendar I have a drop down list (cells C3-D3) of the months May-December for 2018. When choosing one of the months the dates change in cells F8-F42, L8-L42 to create a typical calendar look.
    Right now I have an example of a campsite reservation in July for a couple nights that are shaded red but when I choose August from the drop down to change the calendar dates that July reservation stays in those cells.
    What I want to do is between May and December to input reservations into the calendar and have them stay there as I switch between the months. I'm not sure if this is something that I can do.

    Hope this makes better sense at what I am looking for help with.

    Vanessa

  4. #4
    Registered User
    Join Date
    08-23-2017
    Location
    Northwest Territories, Canada
    MS-Off Ver
    MS Office 2013
    Posts
    6

    Re: Auto Populating calendar that changes all data with each month.

    Hi all,

    Is anyone able to help me with my spreadsheet?

    Thank you!

+ 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. Auto Populating calendar
    By VMurtsell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-25-2017, 04:55 PM
  2. Auto-Populating Calendar
    By emk123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-13-2017, 07:29 AM
  3. Auto Populating Calendar
    By NEWBie32 in forum Excel General
    Replies: 2
    Last Post: 01-19-2016, 06:56 PM
  4. Auto Populating Calendar for Multiple Dates from Column Data
    By TrackingDates in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-18-2014, 03:39 PM
  5. Replies: 2
    Last Post: 04-28-2014, 05:17 AM
  6. Replies: 0
    Last Post: 02-21-2013, 09:04 AM
  7. Calendar VBA auto filling week and month based on calendar entry.
    By perrymagic in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-18-2011, 02:00 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