How do I link text from mulitple cells to another spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two excell spreadsheets, I need to import the text data from one to
the other without doing each cell seperately.
 
Copy the source range of cells.

In target sheet paste special>paste link>ok>esc


Gord Dibben MS Excel MVP
 
Thank you Gord, it worked!

Gord Dibben said:
Copy the source range of cells.

In target sheet paste special>paste link>ok>esc


Gord Dibben MS Excel MVP
Click to expand...
 
You must log in or register to reply here.

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
#N/A In Cells 7
Excel Typed text appears in wrong cell 0
How do I combine information from two separate spreadsheets 2
Heavily linked spreadsheet freezes with "calculating cells 0%" - . 1
Copying text from multiple cells. 1
Determining if a number got hit before another 2
Linking spreadsheet 1

Back
Top