Thanks but I want to Query the worksheet. For ex If I add a new listing to
the master worksheet I want it to automatically add itself to the second
worksheet. Can this be done?

"pinmaster" wrote:


Copy the data that you want from the main worksheet and then paste it
into the other worksheet but don't just paste it, select "Paste
Special" then select "paste as link" hit OK.

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=495632