Dear Moo,

If I want to expand this from Sheet2!$Z$9:$Z$700 whats the changes i need to do.I did normal way but only shows up to 7 items on the list.

Ben[/QUOTE]