list data to show up on multiple sheets

  • Thread starter Thread starter Onehundone
  • Start date Start date
O

Onehundone

I am trying to input a list of names and I was wondering if I can get the
names to automatically appear on worksheet 2 if i input them onto worksheet 1
and reorder etc. Is there a way to do this
 
In Sheet2 A1 enter this formula.

=INDIRECT("Sheet1!A" & ROW())

Copy down as far as you wish.


Gord Dibben MS Excel MVP
 
Here is another possibility... enter this formula on Sheet2,

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

and copy down as needed.

Rick
 
Back
Top