HOW CAN I AUTO FILL A CELL WITH TEXT FROM ANOTHER WORKSHEET TEXT .

[waz]

I am trying to set up several worksheets that will automatically transfer
text typed in a cell to transfer to cells in other worksheets, is this
possible

 

[Nick Hodge]

The formula below will fill say Cell A2 on Sheet1 with the data from A2 on
Sheet2

=Sheet2!A2

If you want nothing to show until it is typed in the other sheet try

=IF(Sheet2!A2="","",Sheet2!A2)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Gord Dibben]

waz

You can "link" the cells to the master cell.

Sheet1 A1 contains "waz"(no quotes)

On Sheet2 A1 enter =Sheet1!A1 and return "waz"

OR you can select several cells in Sheet1 and copy. Switch to Sheet2 and
Paste Special>Links>OK>Esc.

Gord Dibben Excel MVP