ExcelBanter - How do I effeciently share text from two different sheets?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I effeciently share text from two different sheets? (https://www.excelbanter.com/excel-worksheet-functions/59089-how-do-i-effeciently-share-text-two-different-sheets.html)

kristina

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?

Dave Peterson

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

Gord Dibben

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?

All times are GMT +1. The time now is 06:57 PM.