From my browsing of these boards, I am certain that one of the more enlightened members can help me with my problem. Here is my problem:

1. I have 3 stores - all with the same products but with varying price differences to the base price (due to store location)

2. I have one worksheet that has all the sales/cost of goods/price differentials of each of the three stores forcasted out 5 years.

3. Each store has its own worksheet - I use the offset function to pull values from the master data sheet. Pulling sales volumes and costs is not a problem...

4. The problem is pulling sales prices.....there is one last "pricing" worksheet that has a base price for products and adjusts this price for the store differentials found in the master data worksheet. However....obviously this is static and can calculate only one differential at a time ( I put the number 2 in the top left hand corner, the worksheet recognizes that this is store number 2 and pulls the price differentials for store 2 from the master data sheet)....however, since all 3 stores are linked to the same pricing sheet, all thee stores get the same pricing differentials.

phew...

My question: Is there a way, other than copying the pricing sheet 3 times over for the number of stores, to somehow from each store worksheet, "force" the pricing sheet to spit out correct differentials depending on the store sheet I am on....

i am sorry if this is confusing but please help..

thank you very much