+ Reply to Thread
Results 1 to 2 of 2

Need to create/fill in a calendar from a list of dates.

  1. #1
    Registered User
    Join Date
    07-06-2014
    Location
    El Paso, Texas
    MS-Off Ver
    Office for Mac
    Posts
    4

    Red face Need to create/fill in a calendar from a list of dates.

    Hello,

    I use an excel spread sheet to list the payments that I make monthly, to who it's made to, and how much is being sent. Once I make this list, I open up a word calendar and fill in each date with the Payee and the amount that is being paid. It's worked so far, but I'm wondering if there is anything that I can do in Excel to eliminate the step of using Word. I know calendars can be created, but is there anyway I can set it up so that it automatically fills in each date with the Payee and Amount? I'd appreciate any help that anyone could provide me.

    All Best!

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Need to create/fill in a calendar from a list of dates.

    I'd imagine this egg has been cracked 1000s of times. Try Googling "Excel payment calendar" and check the images... looks like tons of starting forms for you to play with.

    None will be exactly what you have in mind...

    http://exceltemplate.net/calendar/bi...ment-calendar/

    ...but find one that is closest and start tweaking, good way to learn at the same time.
    Last edited by JBeaucaire; 09-07-2014 at 05:47 PM.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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: 3
    Last Post: 07-29-2014, 01:20 PM
  2. Fill in a calendar schedule with information based on dates in a column
    By matten7 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2012, 10:10 AM
  3. Replies: 11
    Last Post: 04-07-2009, 04:30 PM
  4. create custom date fill for a calendar
    By Quelyn in forum Excel General
    Replies: 3
    Last Post: 05-26-2008, 08:19 PM
  5. Replies: 0
    Last Post: 03-16-2006, 05:45 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