+ Reply to Thread
Results 1 to 2 of 2

How to get cells to adjust to input from another cell

  1. #1
    Registered User
    Join Date
    08-08-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    1

    How to get cells to adjust to input from another cell

    This is my first post so I'm really sorry if I'm asking an obvious question!

    Iím trying to create a budget in Excel.

    Every week I want to spend £100. I have four types of expenditure: Food, Travel, Weekend and Other. Say I plan to spend £25 on each, and provisionally enter that into the budget

    Please entertain a few scenariosÖ

    I buy a weekís train card for £25 on Monday Ė all fine and dandy, I donít need to update the budget. But then itís Tuesday and I have to catch a bus to a friendís house, spending £3. I want to be able to then update my travel cell to £28, and have all the other cells adjust so that I know now I canít spend £25 on my weekend, but £24, and the same for travel and other.

    Equally, if one week I get lots of discounts at the supermarket and only spend £19, I want to be able to see that on the weekend, travel and other I now have £27 to play with.

    Is there a way to do that?

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,076

    Re: How to get cells to adjust to input from another cell

    Hello fionapotter,

    Welcome to this Forum!.

    Your issue appears to be quite some fun, but to render any help we would preferably like to see what your WorkBook and setup looks like. Could you please upload a sample of your WorkBook so that we can see how best to assist you?
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

+ 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. Need to adjust the length of data for accepted by input vba
    By kjsconv in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-31-2013, 01:05 PM
  2. Cells selecting a word input depending on input of another cell
    By ceeje25 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-14-2012, 07:08 AM
  3. Macro to adjust graphs based on input
    By geotr in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-10-2010, 03:31 PM
  4. Copy cells containing $ sign but still adjust cell number?
    By oatfedgoat in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-17-2007, 05:41 AM
  5. Replies: 1
    Last Post: 01-21-2006, 12:30 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