Copy Column data to other worksheet

's Computer Specifications

Hi there

I have 2 work sheets. Sheet1 & sheet2. I wish to have exact copy of the
data of entire column A1 on sheet1 to sheet2 A1. I also want this to
be synchronized so if data changes on sheet1 then it should replicate
to sheet2 . is it possible to achieve? If so then can you please tell
me how ?

I appreciate your help.

Cheers
Rits

's Computer Specifications

Oppss i am sorry i figured out how to do it

's Computer Specifications

Rits wrote:
> Oppss i am sorry i figured out how to do it
>
How did you do this? I am working with Data/Consolidation and cant get
it to work.

All I want to do is copy non-blank cells from worksheet 2, 3 & 4 into
the first worksheet.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy data in table to column in worksheet	richzip	Microsoft Excel Programming	0	25th May 2010 12:55 AM
Copy data from other worksheet based on column header	sbitaxi@gmail.com	Microsoft Excel Misc	0	29th Apr 2008 08:18 PM
copy column cell data onto another worksheet	=?Utf-8?B?TmdT?=	Microsoft Excel Programming	1	10th Apr 2007 09:00 AM
Copy worksheets to new worksheet and add a worksheet name column to new sheet.	Lib	Microsoft Excel Programming	1	22nd Feb 2007 04:30 PM
How to create a macro to copy data from a column to a row in another worksheet?	NewAtExcel	Microsoft Excel Programming	0	1st Jan 2004 12:38 AM