Whats the best method to link 2 spreadhseets together. They have a
stock code that is the common link between them. 1 sheet has 4168 lines
the other has 14909 lines. The larger one is a FULL list of all stock
codes, the other is a smaller subset, its needed for sections of
catalogues. I want to be able to change the price on the master list
and have it updated on the subset listing.

At the moment I have setup a hiddeous lookup formula - rather messy.

Thanks
Peter.


--
PeterG
------------------------------------------------------------------------
PeterG's Profile: http://www.excelforum.com/member.php...o&userid=16485
View this thread: http://www.excelforum.com/showthread...hreadid=399837