Im using excel 2007 and I would really like to link two cells from same
workbook but different worksheets where if i enter information( text) into
the first cell (Sheet 1 A1)it reads in the second cell (sheet 2 B2) but if i
enter it into the second cell (sheet 2 B2) first it can be read in first cell
(sheet 1 A1). ive tried creating a circular reference but i find that once i
type in the text that it erases the formula.