B
Binyaaust
I have an Excel technical problem to split the cost between divisions. Please
help to create a macro to replace my manual process.
e.g. I have the following data
Division Cost
General 100
Admin 150
If the Division is General, the cost need be split by Key 1, if it is Admin,
split by Key 2, and the original lines will be replaced by three different
lines
Division A Division B Division C
Key1 50% 30% 20%
Key2 70% 0 30%
the result:
Division Cost
Division A 50
Division B 30
Division C 20
Division A 105
Division B 0
Division C 45
Please help! Thanks!!
help to create a macro to replace my manual process.
e.g. I have the following data
Division Cost
General 100
Admin 150
If the Division is General, the cost need be split by Key 1, if it is Admin,
split by Key 2, and the original lines will be replaced by three different
lines
Division A Division B Division C
Key1 50% 30% 20%
Key2 70% 0 30%
the result:
Division Cost
Division A 50
Division B 30
Division C 20
Division A 105
Division B 0
Division C 45
Please help! Thanks!!