Concurrent update

[FoxtrotCharlie]

Hi
I have two worksheets, Sheet one which contains multiple
columns (name,Dept,Age,Gender etc) and the second which
has only two columns (Name, Dept)sorted in alphabetical
order.
As these workseets are part of the same workbook when I
add additional information to first worksheet one can it
be set to automatically add the entry into the second
worksheet?
any tips gratefully received.

 

[Don]

Hi Charlie,

With your columns listed on Sheet1 as you
describe..A,B,C,D,etc...enter all the data on sheet1.

On sheet2 enter column heading Name in column A, Dept in
column B.

Enter formulas as follows on Sheet2 and drag down as far
as you require:

Cell A2 "=Sheet1!A2" with no quotes
Cell B2 "=Sheet1!B2" again no quotes

That'll get you started,

HTH,

Don

 

[Don]

Forgot to mention....do all your sorting on Sheet1 and be
sure to select the entire Range of Data (not the Headings)
as in A2:Z100 (or whereever your last data entry is)

Sheet2 will update automatically.