0
Undo
Votes
I'm looking to utilize the value of the active cell to change the results of formulas in other cells. For this example, I have created a matrix with 1-6 across the top and 1-6 down the side. I want the results of the table to change depending on the value of the active cell. I have created two examples. One where the active cell has a value of 2 and one where the active cell has a value of 3. Therefore depending on which cell I click on the left, it will change the values of the entire table.
Can this be done using functions within the formulas of the table or do I need to have those formulas use a VBA function?
Can this be done using functions within the formulas of the table or do I need to have those formulas use a VBA function?
There are no replies made for this post yet.