list data to show up on multiple sheets

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
 
G

Gord Dibben

In Sheet2 A1 enter this formula.

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

Copy down as far as you wish.


Gord Dibben MS Excel MVP
 
R

Rick Rothstein \(MVP - VB\)

Here is another possibility... enter this formula on Sheet2,

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

and copy down as needed.

Rick
 
Top