Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup did cell auto formating but not displaying complete text.. | Excel Worksheet Functions | |||
how to hyperlink text to a cell | New Users to Excel | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
name of another worksheet in cell for reference | Excel Worksheet Functions |