I'll try to keep this example small so it's easier to understand.
The spreadsheet has 2 "tables" (not really tables, but they are in their own area if you know what I mean).
Table #1: (output)
Cell A's value: 2
Cell B's value: 3
Table #2: (input)
Cell A's value: 1.00
Basically what I want to do is, when I change the 1.00 value in table 2, I want both cell A and cell B in the first table to update to the amount specified in table 2 as a decreased percent value.
So, if I typed 0.95 into table 2, the results should be:
Table #1: (output)
Cell A's value: 1.9
Cell B's value: 2.85
The other piece of the question is, how can I revert the first table's values back to their "saved" state if I change table 2's value back to 1.00? As in, cell A would change back to 2 and cell B would be 3, if I entered 1.00 into the second table's cell.
Thanks. Also keep in mind, I am a newbie to excel. The spreadsheet I'm working on now has about 150 different cells that need to be updated based on 1 value, so if there's an easy way to drag/drop the cells I want modified into a function, please share.![]()
Bookmarks