Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Oppss i am sorry i figured out how to do it
|
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy data from other worksheet based on column header | Excel Discussion (Misc queries) | |||
how to copy contents of one column to another column in another worksheet | Excel Discussion (Misc queries) | |||
Copy column A and column D from all sheets into new worksheet | Excel Programming | |||
Copy column B and column E from all sheets into new worksheet | Excel Programming | |||
How to create a macro to copy data from a column to a row in another worksheet? | Excel Programming |