I am using excel 2003. I have a master worksheet containing product data. I then have seperate worksheets for different ebay, amazon etc which calculates the costs and profitability per product, the product list for which is linked to the master worksheet. However I also have in each worksheet a column for the price we set against each product for the different sales channels this they might be different for the same product across the different channels.

However when I add products to the master list and sort into alphbetical order (needed for reference point for drop down lists in other parts of the spreadsheet) the channel worksheet product lists change order but the prices that we set do not change order.

My question being is there any way to link or anchor two cells together so that they automatically move with each other when one is sorted as a result of the master sheet being sorted?

I hope you can help.

Thanks

Rob