+ Reply to Thread
Results 1 to 3 of 3

Calendar to track expense items

  1. #1
    Registered User
    Join Date
    05-23-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    2

    Calendar to track expense items

    Hello,

    Can someone help me locate a calendar that can track expense items listed in column, almost like budget items, from on one sheet that will auto-populate to a calendar with details and weekly sub totals for the various spending categories?

    I see there are various thread on calendars similar to what I need but I am unsure how build the calendar itself inside of my workbook. I am a true novice at Excel so this may be simple for many of you, but I am coming up short and my boss is not happy.

    Thanks for the help,

    BRF

  2. #2
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Calendar to track expense items

    Your best bet is to provide a sample file of the format & structure you are looking for. Include a few examples of expense items in the file, and show in the calendar what you would want the formulas to return.
    Please click the * icon below if I have helped.

  3. #3
    Registered User
    Join Date
    05-23-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Calendar to track expense items

    Ok, so I have located a calendar program that almost works. I have included the file below. This one is able to take the data in one column and place it on the appropriate day of the month on the calendar. That part works just like I need it to with the exception of the output on the calendar. I would like for the Income and expense numbers to be in $ format as well as be different colors, but i can live with it.

    The next thing I need is to be able to add an additional column for a new list of expenses for another sales person to the same calendar. I have included the second column with example data but have no idea how to manipulate the formula. I need to be able to add information for 4 salesmen on the same calendar. I tried copy and paste of the formula, but could not make it work.

    Anyone have a good idea?

    Thanks,

    BRF
    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)

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