Thank you.
What I had in mind was a inputbox to input Pool 1 then the returned values
should equal Final Ownership.

"Yara" wrote:

Hi Jeff
I think you need to write a formula instead of VBA macro.
Final Ownership, Pool1 Owner A = His share from pool 1 + Share of pool 2
which is 0.25 multiply by his share from Pool 2.

ex. Final Ownership Pool 1 Owner A = 0.25 + 0.25*0.5 = 0.375

I hope this will help.


"Jeff" wrote:

Hi,
I start with the initial Ownership of Pool 1
which owns a portion of Pool 2.
I need a VBA Macro that would return the final ownership based
on the inital ownership.
Ownership must equal 1.
Initial Ownership Final Ownership
Pool 1 Owner A 0.25 Pool 1 Owner A 0.375
Pool 1 Owner B 0.25 Pool 1 Owner B 0.375
Pool 1 Owner C 0.25 Pool 1 Owner C 0.25
Pool 1 Pool 2 0.25
Pool 2 Owner A 0.5
Pool 2 Owner B 0.5