+ Reply to Thread
Results 1 to 1 of 1

Create Auto-Calculating Cell and Assign Cell Values Based on a Macro

  1. #1
    Registered User
    Join Date
    United States
    MS-Off Ver
    Excel 2007

    Create Auto-Calculating Cell and Assign Cell Values Based on a Macro

    At least, I believe you can only do what I'm looking to do with macros. If they can be done with formulas, let me know. I'm already quite well versed on that side of things.

    Basically, I'm making a big character sheet for D&D, and I want things to populate automatically. There are a few issues I'm running into on the programming side of things with that. The other 90% of the work is a lot of data entry for items, stats, classes, races, etc. Here are the problems I'm running into.
    • Create an auto-calculating cell
    One of the things I want to do is have a self-updating cell. This cell would start with the value of a number in a different cell in the sheet (say, for this example, 70). When you select the cell, and enter "-10", followed by a carriage return, the cell would automatically calculate your new entry against the existing number, and display the result of 60. I don't want to have numbers have to be entered or displayed in any cells other than the singular cell I'm trying to modify.
    • Edit a cell based on the contents of another cell
    Based on the nature of this project, there's a lot of "If RACE is HUMAN, add 2 to X and X and X and X and X and X and give POWER and give ABILITY". This would be looking against about 10 values of "race" at a minimum. More for "class", and even more for "armor". Realistically, I don't want to have to modify my number crunching cells from looking like this:

    =IF(G6="X", (C4+5+a!B1), (C4+a!B1))
    To looking like this

    =IF(G6="X", (C4+5+a!B1), (C4+a!B1)+(IF OR(M3="Tiefling", "Dwarf", "Eladrin", "Human", "Squid"), +2, 0)+(IF I22="Strength", J22, 0)+IF(etc, etc, etc, etc, etc...))
    With the number of different IF statements to use approaching the hundreds, just based on the number of things that could theoretically affect a "strength" score.

    What I'd ideally like to do is put a macro out there that works like this logically.

    Please Login or Register  to view this content.
    etc, etc. This would make my life a lot easier. That way rather than everything checking one cell for very, very specific conditions, and making my formulas 100% unreadable in the event they make a change to an existing rule, this would just check the cell itself, and make edits to any cells that matter based on that race.

    Thanks for the input guys, any is appreciated!

    Last edited by Titanium Fox; 08-26-2013 at 12:05 AM.

+ 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. Replies: 3
    Last Post: 11-08-2011, 06:09 PM
  2. Things I have learned about Excel macros
    By Andrew-R in forum The Water Cooler
    Replies: 4
    Last Post: 08-19-2010, 02:40 PM
  3. Things that interfere with VBA Macros
    By Phil_V in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-09-2009, 05:32 AM
  4. Annoying things / Excel
    By Maxwell-5000 in forum Excel General
    Replies: 4
    Last Post: 08-11-2005, 08:05 PM
  5. Can Excel do things like Quicken
    By Justin in forum Excel General
    Replies: 2
    Last Post: 06-16-2005, 07:33 PM


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