Sure you can!

Just follow the procedure i gave you but when you choose a cell to add
the list validation to choose it on the WS2 page, so your list may be
on WS1 column A and your cell that the data appears in can be on WS2!

Give it a go, it worked for me.

Regards,

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=498666