In Excel I want to copy text from spreadsheet to spreadsheet

G

Guest

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

Guest

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
 
G

Guest

if u dont want the link then:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel spreadsheets opening at top instead of bottom. 4
Excel shortcut options 0
spreadsheet 1
Pulling From Multiple Sheet 0
Lookups - how to obtain data from a master spreadsheet into another 5
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Comparing two spreadsheets 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Top