Copying to another worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two worksheets open, when I change a value in Worksheet 1, cell d16, I want to change another cell in Worksheet 2 to the same value, basically automaticaly update both cells at the same time. What is the formula for this
 
On the second sheet, use the formula

='Sheet1'!D16

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

jd2003 said:
I have two worksheets open, when I change a value in Worksheet 1, cell
Click to expand...
d16, I want to change another cell in Worksheet 2 to the same value,
basically automaticaly update both cells at the same time. What is the
formula for this.
 
Back
Top