In Excel I want to copy text from spreadsheet to spreadsheet
 

I have a 12 page worksheet. I would like to pull the TEXT from sheet one to
sheet two and so on. (like I do with my formulas) I can't figure out how to
do this. Can anyone help?

In Excel I want to copy text from spreadsheet to spreadsheet
 

if i got u right :

Activate last sheet-tab where u want text
hold down SHIFT-key
activate all other sheet-tab u want the text
Activate the cell u want text and press =
Activate the sheet and cell where text u want to copy is
Hit ENTER

copy text to all activated sheets and selected cells

In Excel I want to copy text from spreadsheet to spreadsheet
 

if u dont want the link then:

copy ur text
Activate all ur destination sheets
activate destination cell
paste

In Excel I want to copy text from spreadsheet to spreadsheet
 

Perfect!! Thank you


"excelent" wrote:

if i got u right :

Activate last sheet-tab where u want text
hold down SHIFT-key
activate all other sheet-tab u want the text
Activate the cell u want text and press =
Activate the sheet and cell where text u want to copy is
Hit ENTER

copy text to all activated sheets and selected cells