+ Reply to Thread
Results 1 to 3 of 3

Excel Auto Updating Calendar in Monthly view

  1. #1
    Registered User
    Join Date
    01-31-2017
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    2

    Excel Auto Updating Calendar in Monthly view

    Hi guys,

    Hoping someone can assist

    I am trying to create a calendar that only shows months, and will auto-fill the data

    In brief, my boss wants to be able to see when we see clients over the whole year

    I have attached what I have so far (with the assistance of some other threads), however it will not auto-populate for the second half of my data... no matter what I do to the formula

    Please see attached

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Excel Auto Updating Calendar in Monthly view

    Just expand the range in formula: Sheet1!$A$4:$A$45 to bigger , i.e Sheet1!$A$4:$A$450

    Make sure that array formula confirmed by Ctrl-shift-enter, rather than enter only.
    Quang PT

  3. #3
    Registered User
    Join Date
    01-31-2017
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    2

    Re: Excel Auto Updating Calendar in Monthly view

    Legend. 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. Replies: 9
    Last Post: 08-09-2016, 01:19 PM
  2. [SOLVED] Updating purchase order (PO) on the monthly calendar
    By dogbural in forum Excel General
    Replies: 17
    Last Post: 12-30-2014, 09:53 AM
  3. Auto Updating of 100+ Files from Data File on Monthly Basis
    By ats1312 in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 10-09-2013, 11:53 AM
  4. Auto Updating Calendar
    By briangutan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2012, 07:16 AM
  5. Replies: 2
    Last Post: 04-13-2012, 01:16 PM
  6. Modify Yearly Calendar to Monthly Calendar Excel 2000?
    By James Cooper in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-13-2006, 06:50 PM
  7. [SOLVED] Spreadsheet To Auto Generate Monthly Calendar
    By ATL10SPRO in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2006, 12:25 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