Excel updates on new document not existing

January 10, 2011 at 09:21:09
Specs: Windows XP
Every time I enter data into a cell on Sheet1 I would like it to automatically enter into a different cell on Sheet2.

I use the formula =Sheet1!A2 on a clean document, but the formula doesn't work on my existing document with data already entered on both sheets.

See More: Excel updates on new document not existing

Report •

January 10, 2011 at 15:57:07
What do mean when you say "the formula doesn't work?"

When you enter =Sheet1!A2 does it not return the value from Sheet1!A2? What does it return?

Is the cell formatted as text by any chance?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question