In Excel I want to copy text from spreadsheet to spreadsheet

K

Kris

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?
 
E

excelent

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
 
E

excelent

if u dont want the link then:

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