Linking Data in diff worksheets

**cuteangelika** · 02-27-2007, 09:33 PM

Hi,

Need your help with my excel dilemma...

I would like to replicate a column from sheet 1 to sheet 2 where input will be only done in sheet 1. Input is done by copying previous row & inserting it after (it's alphabetically sorted and user will insert data in the appropriate row).

At first, I just did a direct link where my column in sheet 2 had =Sheet1!A1. Problem is, when a row is inserted in Sheet 1, it is not reflected in Sheet 2. The formula is just out of order (i.e. =A1, =A2, =A5). Then I changed it to "=Sheet1!$A$3" but still had the same problem.

Is there any way to solve this? Thanks!

**BigBas** · 02-27-2007, 09:36 PM

Any chance you could upload a copy of your spreadsheet so we can help you best?

**cuteangelika** · 02-27-2007, 09:46 PM

here you go.. thanks

please ignore the formula.. i deleted the other sheets with names..

kindly just focus on column a for both task list and resource summary sheets.
thanks!

**davesexcel** · 02-27-2007, 09:53 PM

Hi,
Maybe this could help...
place this code in sheet1 module
right click on the sheets tab at the bottom of the screen and select View codes
copy and paste this code there.

this code will auto sort when you enter data in column A Sheet1,and also have Sheet2 show the same data, sorted the same way.

Please Login or Register  to view this content.

This code can easily be changed to sort more columns and copy more columns

**cuteangelika** · 02-27-2007, 10:02 PM

wow davesexcel!!!! this is exactly what i wanted..
thanks so much.
Makes my life so much easier :-)

**dnorriss** · 06-09-2011, 12:13 PM

Hello there,

I'm struggling to work out how to add more columns to be copied.

can someone tell me how?

Many thanks,

Dom

**jmerlo** · 08-05-2015, 07:28 PM

I used the code and it worked perfect in my worksheet too. My problem now is that is doesn't respect the data in sheet 2. If I have a new row in sheet 1 it changes the information in sheet 2.

Is there a way to fix this?
Thanks!

**FDibbins** · 08-05-2015, 08:20 PM

Hi jmerlo, welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.