Results 1 to 3 of 3

How to add new data to existing cell based on multiple selective inputs?

Threaded View

  1. #1
    Registered User
    Join Date
    04-01-2009
    Location
    Houston, TX
    MS-Off Ver
    Excel 2003
    Posts
    2

    How to add new data to existing cell based on multiple selective inputs?

    I know what I want to do, just not how to do it or describe it, so please forgive me if this doesn’t make any sense.

    I have a spreadsheet of courses required to reach a certification. On this spreadsheet I have listed the number of hours required for each course in one column, and how many hours I have accrued in an adjoining column. Not all the hours will occur at once, so I tend to bound from cell to cell adding hours in small amounts. What I am trying to do is create a macro that will allow me to add to the existing number of hours to the newly accrued hours, without typing over what is already there.

    For example…Class 1 requires five hours total, and I have two hours accrued. If I accrue two more hours (for a total of four hours) I want to update cell E2 without going in to this cell manually and changing this number. I would like to enter the additional two hours in a text box or similar function, and have that function update E2.

    To add to the level of difficulty, there are four levels of class. This means not only do I need to be able to select which class hours need updated, but which level of class.

    I have attached the spreadsheet I am working with to try to make things a little clearer. I hope.
    Attached Files Attached Files
    Last edited by AlphaSvn; 04-01-2009 at 06:09 PM.

Thread Information

Users Browsing this Thread

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

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