Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kristina
 
Posts: n/a
Default How do I effeciently share text from two different sheets?

Please help. I want to link two different sheets, many cells... like a whole
column at once. TEXT!!! Any advice?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default How do I effeciently share text from two different sheets?

Select the range
edit|copy
select the top left cell of the range to paste
edit|paste special|Click paste link



kristina wrote:

Please help. I want to link two different sheets, many cells... like a whole
column at once. TEXT!!! Any advice?


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default How do I effeciently share text from two different sheets?

kristina

Select the entire column in Sheet1 and copy.

Switch to Sheet2, select A1 and Paste SpecialPaste LinksOKEsc




On Tue, 6 Dec 2005 14:29:03 -0800, "kristina"
wrote:

Please help. I want to link two different sheets, many cells... like a whole
column at once. TEXT!!! Any advice?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count Intervals of Filtered TEXT values in Column and Return Count across a Row Sam via OfficeKB.com Excel Worksheet Functions 9 July 31st 05 03:37 AM
copying text across sheets nospam Excel Worksheet Functions 1 July 26th 05 07:05 PM
Autofitting a row Josephine Excel Discussion (Misc queries) 2 March 3rd 05 03:37 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
How do I compare two columns on seperate sheets and replace text . hag400 Excel Worksheet Functions 1 December 28th 04 02:32 PM


All times are GMT +1. The time now is 10:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"