Copy Column from Sheet1 to Sheet2

[h.noor]

I am looking to simply copy Column A from Sheet1 to Sheet2. My Column A has over 2000 entries and it is updated constantly. I am looking for a way so that whenever I updated Column A in Sheet1 it gets automatically updated in Column A, Sheet2. What are the ways this can be accomplished automatically each time the list is updated?

Really appreciate any help. Thank you.

[bob33]

create a formula link from sheet 1 to sheet 2 in the appropriate cells.

[h.noor]

bob33, thank you for a quick reply. How can I accomplish that?

[bob33]

if cell a1 on sheet 1 contains: 324
on sheet 2, in cell a1 enter: =sheet2!A1
then fill that formula down the column on sheet2 to whatever row you want it to stop reflecting sheet1 content.
sheet2, cell a1 should have 324 in it.

[sakib]

Hi H Noor,

There is a simple way to do this using the below formula:

='Sheet1'!$A$2

Write this formula for each row separately changing the row numbers of ColimnA in Sheet1.

Or by this way:

Simply type = in the columnA or any column you want of Sheet2, then go to Sheet1, ColumnA, click the first row and pres enter. Then in Sheet2, drag down as much as you need.

See the attached file and test with changing the existing data and inserting new dat in Coulmn A of Sheet1, you will see that ColumnA in sheet2 is changing accordingly.

Hope this will help you. If you are satisfied, then don't forget to send me the reputation.

Thanks.

Sakib

[sakib]

Dear H.Noor

Forget to mention that, if you follow the first option of my suggestion, you need to type the formula in Sheet2, ColumnA or wherever you want to copy the data...

Thanks.

[h.noor]

Sakib and Bob, it works great but the problem is that when I update Sheet1 list Sheet2 does not get updated automatically this way. Is there another way?

[bob33]

You'll have to hit save; that should update the fields.

[h.noor]

This function doesn't work properly for me. Is there a Macro I can use to automate this process?

[jolivanes]

You could try this. Copy this code into the Sheet1 module

Please Login or Register  to view this content.

If "updating" means that it is possible that data will be deleted from Column A, you could try this

Please Login or Register  to view this content.