Formula or VBA for auto changing of qty based on a Value

[RAMU]

Dear Friends,

Suppose I have a data like the following:

FRUITS	QTY	RATE	TOTAL
APPLE	125	40	5000
GUAVA	83	65	5395
ORANGE	52	10	520
BANANA	78	5	390
GRAPE	75.25	45	3386.25
LEAMON	32.5	15	487.5
LITCHI	38.52	30	1155.6
DATES	56.75	62.5	3546.875
CHERRY	23.2	28	649.6
PAPAYA	26	16	416
COCONUT	15	20	300
		GRAND TOTAL	21246.83

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

Total column is simple multiplication of Rate & Qty and Grand Total is normal SUM formula.

"FRUIT" is in A1 & "21246.83" is in D13. In G13 I have put the same figure of Grand Total i.e. 21246.83 manually.

What I need basically a formula in a column or VBA by which if I change the value of G13, Constant the rates the qty of all fruits will be changed automatically on pro rata basis or percentage basis of total qty of fruits.

Thanks in advance.
Regards
RAMU

 

[Joe4]

Place this formula in cell E2 and copy to cell E12:

=B2*($G$13/$D$13)

I think that should give you what you want.

 

[RAMU]

Place this formula in cell E2 and copy to cell E12:

=B2*($G$13/$D$13)

I think that should give you what you want.

Hi Joe,

Gr8...!!! It works perfect

Regards
RAMU