I'm not familiar with list manager/wizard.

As I said before, copy the formula down the column as far as you need. To do
this, select the cell with the formula in and copy it (Ctrl-C). Select the
cells you want to copy to, then paste (Ctrl-V).

As you want to ignore row 1, enter the formula in A2 referencing Sheet1!A2.
This assumes the lists are both in column A, but they could be anywhere, not
necessarily the same column or row on both sheets.

Ian

"kpcurt0" wrote in message
...
Thank you very much for your help. Will this work if I am using the list
manager/wizard? This formual only works in a single cell, so how do I
make
it work for an entire column in a list. I need it to ignore row1 in both
sheets because it holds the titles to my lists. I have tried telling it
to
repete the formula (as it relates to its relative cell names)down the
column,
but I then I have to determin a starting and stopping point, and I need it
to
work for the entire column no matter how many cells their are (except the
first cell A,1the title of the list for column A) Thanks again!