Hello everyone, I am new here to this forum! First post . Here is the issue I am having that I need help with: I have 4 columns with many, many rows of data. I am trying to figure out a way to get the numbers in 3 columns to auto update when I change the number in the first column. For example, if I have A1=1, B1=2, C1=3, D1=4, and I change A1 from 1 to a 2, I would like the remaining three columns to auto update(B1=4, C1=6, D1=8). Or for another example, if I changed A1 from 1 to .5, I would want the remaining three columns to auto update to B1=1, C1=1.5, D1=2. How do I go about doing this, do I need to utilize a formula, function, or something else?? Also, if there is a solution, can I mass apply it to all of the other rows of data I have? So that, for example, cells B2 C2 D2 would change if I changed A2, and B3 C3 D3 would change with A3 and so on...?? Thanks!!
Bookmarks