Auto calculate table entries from multple inputs

**FinanceGuy** · 04-30-2010, 08:48 PM

Per the attached spreadsheet, I'd like to find a way to auto fill in the table in column N titled Proceeds. I would like to automatically enter the numbers in Column M into field B6, get the answer in field J13, and enter it into the appropriate place in the table, then go on to the next entry.

Any tips....?

Thanks,

FG

**DonkeyOte** · 05-01-2010, 03:42 AM

Lack of response to a post like this is normally an indication that people aren't quite sure what you're after ...

Are you looking for help regards establish cumulative "purchase" value for each individual or something else ?

Presumably you need to keep a log of cumulative purchases for each individual so as to be able to calculate the correct "proceeds" for any additional purchases ?
(ie given the % tranche differences the "caps" on associated proceeds are different for each person)

If you elaborate a little I'm sure you'll get a prompt resolution from the board as a whole.

**FinanceGuy** · 05-01-2010, 03:50 AM

I just figured it out!!! Use a data table. Couldn't quite see how it worked, but pounded away for long enough and got it. Thanks for any and all who looked to help.

FG

**royUK** · 05-01-2010, 04:22 AM

I looked at the example,but your layout doesn't make any sort of data functions usable

**royUK** · 05-01-2010, 04:22 AM

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save