Data shifts on adding new customers

[Pete]

Hi
Need to stop the data in both Supply and Demand Tables in worksheet "Volumne Summary"....

OK kindly follow the following sequence:

1. Goto worksheet "Volume Summary"

2. Note the highligted name in column B for supply NWS and for demand Other_Market_EU

3. Goto worksheet "Deal Selection" and in column B and I add Shell at the bottom of the current list.

4. Go back to worksheet "Volume Summary" and you will notice that the highighted yellow has moved along shifted down 1 row: Hence, making all the sums in the column F onwards all out of line by one column.....

[Bob Phillips]

1. Vioolume Summary was already selected

2. Didn't note that, Other_Market_FE was highlighted

3. Went to Deal Selection and added Shell

4. Went back to Deal Selection and nothing had changed, same row highlighted

How does the highlight change the sum?

[Pete]

Hay!!! If add shell as new supply and demand customers.....I can asure you that the higlited row moves on the worksheet "Volume Summary" from NWS to NLNG_SPA_1 column B - supply i.e. from row 46 to 47

and also - Demand from
Other_Market_EU to Other_Market_FE...from row 64 to 65

[Pete]

Hay!!! If add shell as new supply and demand customers.....I can asure you that the higlited row moves on the worksheet "Volume Summary" from NWS to NLNG_SPA_1 column B - supply i.e. from row 46 to 47

and also - Demand from
Other_Market_EU to Other_Market_FE...from row 64 to 65

[Pete]

it does not change the sum but allocate the sum to the wrong client....