I would like to do the following: Fill in a cell with an equal statement,
for ex, in cell B6 type "=n135". What I would then like to have happen is
cell d6 automatically fill with what is in p135 and for cell e6 to
automatically fill in with q135. I need the conditional because I want to be
able to change cell B6's value with different cell values, ie n245, n600, n4,
and have cells d6 and e6 automatically follow with the same row but different
columns.
Any help would be greatly appreciated.