+ Reply to Thread
Results 1 to 4 of 4

Automatically update monthly calandar with the data

  1. #1
    Registered User
    Join Date
    04-07-2017
    Location
    INDIA
    MS-Off Ver
    2010
    Posts
    2

    Automatically update monthly calandar with the data

    hello all,
    I have some data which has target completion dates.
    I want to a monthly calandar for next 1 year which automatically fetches the data & shows on calandar.
    Please refer the attachment. (as data i have input as "Eng change -xxxxx" which are to be completed on a target date and would be in separate sheet)

    Regards,
    Sundeep
    Attached Images Attached Images

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,609

    Re: Automatically update monthly calandar with the data

    Sure it can be done with relatively simple vba code. but to propose one we need exact layout of input data and exact layout of output sheet(s) so please attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    04-07-2017
    Location
    INDIA
    MS-Off Ver
    2010
    Posts
    2

    Re: Automatically update monthly calandar with the data

    Uploded sample file for Jan & Feb-18. similar kind of data will be applicable to consecutive months.

    Thanks, Sundeep P
    Attached Files Attached Files

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,609

    Re: Automatically update monthly calandar with the data

    Try such macro:
    Please Login or Register  to view this content.
    Make sure formatting in input cells and calendar cells is the same (I used default one).
    See attached workbook
    Attached Files Attached Files

+ 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. Monthly update of main spreadsheet using data from Payroll file
    By carlos.delossantos in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2015, 03:22 PM
  2. Automatically create monthly totals from daily data
    By honeylhany143 in forum Excel General
    Replies: 2
    Last Post: 05-23-2014, 10:36 AM
  3. add data into a calandar sheet
    By 007Chris in forum Excel General
    Replies: 7
    Last Post: 01-02-2014, 06:31 AM
  4. Merge sheets into one, update bi monthly of new data
    By Pattybreslin in forum Excel General
    Replies: 3
    Last Post: 06-20-2013, 08:51 AM
  5. [SOLVED]Count data monthly automatically
    By patehi in forum Excel General
    Replies: 16
    Last Post: 12-04-2012, 04:41 AM
  6. Automatically update existing data using a Update command button
    By 9999335 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2012, 09:46 PM
  7. Excel 2007 : Automatically filtering data monthly
    By rraze in forum Excel General
    Replies: 3
    Last Post: 07-15-2011, 05:41 AM

Tags for this Thread

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