replicating a column from master sheet to other sheets and sorting on the master sheet

[kstormy1983]

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 sheet 1 is sorted alphabetically the data associated to sheet 2 dose not move with it.

[Pete_UK]

Use a formula like this in A1 of Sheet2:

=INDEX(Sheet1!A:A,ROW(A1))

then copy down. If you then sort column A of Sheet1, then Sheet2 will show the sorted list. If you insert a new row on Sheet1, you will have to copy the formula down again in Sheet2.

Hope this helps.

Pete

[kstormy1983]

this is my first time using this forum so I'm hoping I attached my file ok. What I am trying to do if when we hire new employees on the first sheet I can alphabetize the list and all the other list will alphabetize and corresponding data follows.
thanks