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

Sure. Use a worksheet_change event in the sheet module.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Onehundone" wrote in message
...
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

On Sat, 28 Jun 2008 10:10:00 -0700, Onehundone
wrote:

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

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

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

and copy down as needed.

Rick


"Onehundone" wrote in message
...
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