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

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

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
HIS


"waz" wrote in message
...
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

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 SpecialLinksOKEsc.

Gord Dibben Excel MVP


On Tue, 28 Dec 2004 23:01:02 -0800, waz wrote:

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