One Long Vertical Row to write script in vs lots of horizontal rows - How?

glennparis 

It's far more helpful to post a copy of the actual spreadsheet rather than an image.

That said, I'm not a macro or VBA user, but it's definitely my impression that those features occupy their own space on separate tabs, not to the right of a "normal" spreadsheet. So you may be asking for something that doesn't exist.

That said, what is it that you want this sheet to do, leaving aside the question of a VBA script...from the looks of the left side, you're wanting fairly routine financial calculations, so it's entirely possible that you don't need a script in the first place.

So could you describe the purpose of the spreadsheet itself, and what isn't yet working, what results are desired. Let the various experts here offer VBA as well as non-VBA solutions, if possible.