Hi Ralph,

Weird, I got the Ref thing too. Overcame it by doing this. Enter = in your
sheet 2 cell. Select the 1st sheet and click on G3. Now finish the formula
with ="","", and then reclick G3. Gave me the exact 'looking' formula but
works fine.

I tried a re-enter on your ref formula by F2 Enter and it brought up
MyDocuments file folder of Excel workbooks....????

On your copy paste formula I deleted everything between the ( ) and did it
manually like above and worked fine. A new one on me.

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?