I have 6 worksheets in a workbook. Each worksheet is a unique product form. All the forms take the same product information, but display it differently. The first worksheet gets it data through Microsoft Query and each subsequent sheet is a reference to the first sheet. Here's my current problem. Sometimes, for example, the product name needs to be typed slightly differently on each wksht. But since wkshts 2 - 6 are references, when I click into them to edit how the product name is displayed, I can only edit the formula. Is there a way to make wkshts 2-6 be equal to the values of sheet1 so I can edit the names without retyping them completely? I hope this was clear and thanks as always for your help.
Mark
Mark