+ Reply to Thread
Results 1 to 2 of 2

Inventory List: Change value of one column based on another column's value

  1. #1
    Registered User
    Join Date
    01-11-2017
    Location
    Berlin
    MS-Off Ver
    2010
    Posts
    1

    Inventory List: Change value of one column based on another column's value

    Hello there!

    I am using Microsoft Excel to update an inventory list. I have three main columns as follows:
    A2 represents the total number of boxes in the office and A3 represents the total in the basement.

    A1 A2 A3

    It has to follow these rules:
    A1 represents a total amount equal to A2 + A3
    When one box is brought into the office, the value in the column representing the basement amount should decrease. In other words, an increase (or decrease) in A3 should correspond to a decrease (or increase) by the same amount in A2.

    How can I do this?

    Thanks for your help!

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: Inventory List: Change value of one column based on another column's value

    I would add a tfr column (for transfers) see example. Then you could use that in a formula.
    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)

Similar Threads

  1. [SOLVED] Worksheet Change help: do not show validation list (Column D) if column A is blank
    By skyping in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2016, 10:16 AM
  2. Replies: 5
    Last Post: 01-24-2016, 01:04 AM
  3. Replies: 3
    Last Post: 12-16-2015, 05:56 PM
  4. Change column in formula based on drop down list
    By tantcu in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-07-2013, 09:17 PM
  5. Change colour in column C based on Column B - future dates
    By kfwiss in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-22-2013, 05:47 AM
  6. Replies: 4
    Last Post: 09-05-2012, 01:50 PM
  7. Code to loop through a column and change cell value based on list
    By davekippen in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-13-2011, 04:27 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