+ Reply to Thread
Results 1 to 2 of 2

Advance The Month While Triggering Certain Charges

  1. #1
    Registered User
    Join Date
    08-28-2014
    Location
    Arizona
    MS-Off Ver
    2013
    Posts
    11

    Advance The Month While Triggering Certain Charges

    Hello,

    I'm working on drawing up a budget in Excel. What I'm wanting to do is be able to forecast my budget out as many months as I want. The idea is this; when I copy and paste my budget a column to the right, the budget will automatically move forward a month from the column before. Then, certain expenses will show up depending on what month it is. I can get the months to increment but I can't get the charges to show. I guess I need a formula that will read the value of the cell (I want it to read "December" and trigger a charge; it doesn't do that right now even though the cell says December. I think it's because the "December" cell has a formula that is the prior month's cell + 30). Any ideas? Thanks!

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Advance The Month While Triggering Certain Charges

    Perhaps if you upload a mock example including BEFORE & AFTER sections (hand typed) we will have a better idea. Be sure to show the layout you intend to use.

    If you are not familiar with how to do this:

    To attach a file to your post,
    • be sure to desensitize the data
    • click “Go Advanced” (next to Post Quick Reply – bottom right),
    • scroll down until you see “Manage Attachments”, click that,
    • click “Browse”.
    • select your file(s)
    • click “Upload”
    • click “Close window”
    • click “Submit Reply”

    The file name will appear at the bottom of your reply.
    Dave

+ 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. [SOLVED] Macro To Advance Month
    By robertguy in forum Excel General
    Replies: 12
    Last Post: 12-02-2015, 07:19 PM
  2. Macro to advance Graph Ranges To Accommodate new month
    By robertguy in forum Excel General
    Replies: 2
    Last Post: 08-29-2014, 03:07 AM
  3. [SOLVED] Freight charges based on zip
    By someko in forum Excel General
    Replies: 15
    Last Post: 04-20-2011, 09:20 AM
  4. Advance to new month macro???
    By pril in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-29-2008, 09:08 AM
  5. A few questions (rank and charges)
    By zwgator in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 10-09-2006, 05:33 PM
  6. [SOLVED] VBA to calculate charges
    By choo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-05-2005, 10:20 PM
  7. [SOLVED] Advance A Date By Month Or Year
    By Minitman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-17-2005, 04:06 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