How can I display a column in one workbook to another automaticaly

's Computer Specifications

I have a column H in worksheet 1 and I want its data to be displayed in
column B of worksheet2: without manually cut and pasting, is there a way for
me to move the data to that other worksheed?

's Computer Specifications

In B1 of worksheet2 put =Worksheet1!H1 and then drag it down

"Mike" wrote:

> I have a column H in worksheet 1 and I want its data to be displayed in
> column B of worksheet2: without manually cut and pasting, is there a way for
> me to move the data to that other worksheed?

's Computer Specifications

Copy range of data in column H then switch to sheet2.

Select B1 and Paste Special>Paste link>OK>Esc

Gord Dibben MS Excel MVP

On Wed, 18 Jun 2008 06:52:01 -0700, Mike <(E-Mail Removed)> wrote:

>I have a column H in worksheet 1 and I want its data to be displayed in
>column B of worksheet2: without manually cut and pasting, is there a way for
>me to move the data to that other worksheed?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Second workbook (book2) opens automaticaly	DDavid	Microsoft Excel Misc	9	16th Nov 2009 03:19 PM
Search for a column based on the column header and then past data from it to another column in another workbook	minkokiss	Microsoft Excel Programming	2	5th Apr 2007 01:12 AM
Based on a condition in one column, search for a year in another column, and display data from another column in the same row >> look	MPSingley@midamerican.com	Microsoft Excel Programming	2	30th Dec 2006 06:23 PM
loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook	burl_rfc	Microsoft Excel Programming	1	1st Apr 2006 08:48 PM
How to automaticaly hide all toolbars in in workbook when another workbooks are open?	Igor Sudnik	Microsoft Excel Programming	1	18th Aug 2004 09:05 PM