#1
|
|||
|
|||
Code that will run when a cells value is changed.
Hi. I've been looking for an answer and can't find what I'm looking for. I'm really new to this and could use any help I can get. Thank you in advance.
I have a spread sheet with columns A= Current B= Change Amount C= New Amount I= Percent Change What I need is a code that If I were to change the value in "Change Amount" That it calculates a value in the corresponding "Percent Change"(from a formula). But there will be times that the "percent change" value will change instead, therefore needing to update corresponding "Change amount" (also from a formula) There is roughly 100 rows in the spreadsheet. It will always be a random cell in the range that changes, and sometimes more that one will be. Is there an easy way to do this? Thank you again for any help! Don |
#2
|
||||
|
||||
I am not sure why you would need a macro for this. On the face of it, only simple calculations are required.
What are the relationships between A, B & C?
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
Thank you for the reply. I apologize it took so long for me to get back to you.
I was thinking the same thing...I'm not real sure how to do go about that either. A(current) is the only cell that doesn't change. B(If B is changed, cells "C and I" need to calculate. If they change C the cell B and need to calculate. If cell I is changed then cell B and C need to calculate. It doesn't look like I mentioned it above, but these cells are already populated, and there won't be any set way they enter data, so it just needs to be fool proof where it can't be broken. (They need a way to revert the numbers if they don't like the ending figures as well.- Essentially what they will be doing is playing with numbers. ) I think where I'm really struggling is if they change a cell that has a formula in it, and decide they don't like it, so they play with the other cells, then they have wiped out the formulas. Thank you again. I do appreciate the help! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Highlight cells with changed data on a worksheet with tracking changes | jpb103 | Excel Programming | 1 | 06-03-2014 07:33 AM |
Need to delete 'field code changed' in my reference list | leb | Word | 4 | 05-04-2013 12:25 AM |
Cells no longer wrap text when changed in nested table | erik2000 | Word Tables | 1 | 03-29-2013 03:27 PM |
Unlocking cells with VB code in excel 2003 | tadleymansions | Excel | 1 | 01-18-2013 06:55 AM |
VBA Code to auto resize cells when text entered | OTPM | Excel Programming | 0 | 09-18-2011 04:21 AM |