Programming Questions? Ask a Programmer for Answers ASAP
can you send your sheet and provide a description of what you are trying to accomplish.
you can try a 3rd party site like
after uploading they give you a file ID#
paste it here.
i will really need to see how the dat ais arranged to be able to help you.
sorry, I am not responsible for the way they do the billing.
following your example, I am not sure how cell b1 would influence any of the other cells. If B2 is A1 - A2. What is cell b1 supposed to represent,
How would altering the B1 cell effect the B2 cell value if it is not used in any formulas?
i have the sheet, but it doesn't help me see the big picture of what you want to acomplish? What does cell v92 represent what is your goal?
lets try this a different way, the only way v93 is 0 is if both u92 and u93 are the same.
since the value of u93 is not changing wouldn't it always be whatever u92 value is to make v93 = 0
the value that is in u92 is the value you are trying to get correct?
i could create a macro that did it,
but you may want to check out one of excels built in tools first.
It is called Goal Seek and does exactly what you want.
You may have to install the analysis toolpack add in and solver add ins before you can find it on the menu.
here is more information on it.
let me know if this helped you or not.
so you don't want my help?