Hi,

I am trying to link cells containing more than just data between worksheets, and after about an hour of trying to copy and past or find a formula and googling for help I've about given up. The workbook is in excel 2007.

-i have two sets of sheets, one set contains models organized by retailer, and the other is composed of retailers organized by model.

-each slide has a photo of the product (garden tools in case you are wondering) and the model name written in it. (its more of a visual presentation than analysis)

-I would like to make it so that if I change the text in models organized by retailer, the same slide in retailers organized by model also changes.


thanks for any help or advice you can provide