Formula(s) for these tables to create some stats.

[sakib]

Hi,

I am stuck with these tables.

The idea is for me to copy new info in the 3 yellow sheets (always a similar layout, except that more months, more products, more customers will make the basis bigger), and the green sheets to be automatically updated and sorted (when requested).

So there are 7 sheets to work on, they are mainly similar except one 'Stt MBC' which is different.

On BASE 1 PRT
Column B is the Product Code
Column C is the Product Name
Product Qty is always the first line (7, 11, 15,etc)
Product turnover is always the second line (8, 12, 16, etc)

On BASE 2 COM
Column A is the Customer Code
Column C is the Customer Name
Customer month turnover is always the 4th Column - the 5th Column {4-5}

On BASE 4 BC
Column A is the Customer Code
Column C is the Customer Name

So my calculation on sheet "Stt Pdt - Best Worst" should be from BASE 1 PRT.
But BASE 2 COM would be used for all the other pages.

Also, on each page:
M means Month
M-1 means last month = for today, it would be April
M-2 means last month" +1" = for today, it would be March
etc

Q means Quarter
Q-1 means last quarter, 3 last month = for today it would {April + March + February}
etc

I am not sure how to make the relation between the input tables to generate auto results in the output tables. I need the formula(s) or function(s) to generate results not only for the existing data but also when I will put new data the new results should generate automatically.

Regards.

Sakib