J
jmartineau
I have a row of formulas in one sheet that need to refer to a column
of values in another. That is, in the formula sheet, I have a row like
this:
A1: "=Data!A1"
B1: "=Data!A2"
C1: "=Data!A3"
D1: "=Data!A4"
Is there an easy way to get this to work so that I can either copy and
paste or use Fill Right to generate more formulas in the row, and have
them refer to the corresponding column values in the data sheet?
Thanks!
of values in another. That is, in the formula sheet, I have a row like
this:
A1: "=Data!A1"
B1: "=Data!A2"
C1: "=Data!A3"
D1: "=Data!A4"
Is there an easy way to get this to work so that I can either copy and
paste or use Fill Right to generate more formulas in the row, and have
them refer to the corresponding column values in the data sheet?
Thanks!