R
Ross Mau
I have an excel workbook with multiple worksheets. How do I create a
cell on each of the pages such that if I change it on any one sheet, I
will get that value in the cell I want on each individual worksheet?
If that's not clear, let's say on sheet 1 I want A1 to be tied to A2
on sheet 2. If I change sheet1 A1 I want sheet2 A2 to change to the
same value. Likewise if I change A2 on sheet 2 I want sheet1 A1 to
take the same value.
cell on each of the pages such that if I change it on any one sheet, I
will get that value in the cell I want on each individual worksheet?
If that's not clear, let's say on sheet 1 I want A1 to be tied to A2
on sheet 2. If I change sheet1 A1 I want sheet2 A2 to change to the
same value. Likewise if I change A2 on sheet 2 I want sheet1 A1 to
take the same value.