Hi Ralphb,

Perhaps something like this in sheet 2 and pulled down far enough to cover
the list in sheet 1.

=IF(Sheet1!A1="","",Sheet1!A1)

HTH
Regards,
Howard

"RalphB" wrote in message
...
I have a list on one sheet and would like to show the same list on
anothersheet. The problem is, I want the list on sheet2 to be updated at
the
same time the list on sheet1 is changed so that both they are always the
same. Both sheets are in the same workbook. Can anyone one help?