Results 1 to 6 of 6

How do I Create a Reusable Table for Monthly expenses?

Threaded View

  1. #1
    Registered User
    Join Date
    12-07-2016
    Location
    Washington D.C.
    MS-Off Ver
    Office 365
    Posts
    7

    How do I Create a Reusable Table for Monthly expenses?

    Hello,

    My goal is to create a table where I can change the Month and have it show my monthly expenses for that month. I would like the headers to stay the same each month and the "Itemized Totals" row to appear for each month. Please see this screenshare video for a more detailed description: https://cl.ly/3o1e1g1W1n2H. I attached a screenshot of the table below - I currently have the month as a drop down. But i would like the table data to change as I change the month. I would appreciate any suggestions! Note this table also feeds into a master spreadsheet where I keep track of all my expenses. (The screenshare video shows all this in a more straightforward way).

    What I want to accomplish is in sheet 2. Right now I have the table set up with December at the top and each subsequent month below.
    (Dec, Jan, Feb etc.)

    Column A which has the month names is a drop down menu from which I can select the months. However what I want to be able to do is have one
    central table where I can switch months and have the data change too.
    This data also feeds into sheet 1 in the corresponding fields.

    I created a video with a demonstration to describe what I want to do here: https://cl.ly/2I0a3Y3L1Q2H. I also attached the file to this post.


    Any suggestions?
    Thanks!

    Ryan
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to Create a Reusable Table for Monthly expenses
    By ryancd94 in forum Office 365
    Replies: 3
    Last Post: 01-10-2017, 01:36 AM
  2. Recurring Monthly Expenses
    By zn_pipkns in forum Excel General
    Replies: 1
    Last Post: 03-04-2014, 07:38 AM
  3. Expenses, formula for monthly / annual / etc
    By Ricardo Mass in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-09-2013, 04:14 PM
  4. Need to keep a running annual average of monthly expenses
    By sound chaser in forum Excel General
    Replies: 1
    Last Post: 09-01-2012, 11:35 PM
  5. Replies: 0
    Last Post: 05-19-2009, 04:59 PM
  6. [SOLVED] Calculating monthly budget expenses
    By Warrain in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-15-2006, 07:00 PM
  7. How do I create a reusable template
    By Jami in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-25-2005, 02: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