View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do I link text from mulitple cells to another spreadsheet

Copy the source range of cells.

In target sheet paste specialpaste linkokesc


Gord Dibben MS Excel MVP


On Tue, 10 Jul 2007 14:40:02 -0700, Pat wrote:

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