Concurrent update

  • Thread starter Thread starter FoxtrotCharlie
  • Start date Start date
F

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.
 
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
 
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.
 
Back
Top