Dynamic Table

[efrosen]

I have two variables, Fee and Tenor, which I want to base a table on. Tenor across the top, and fee vertically. I know there is some way to do this, but I can't remember how: I want the table, in each box to insert its respective Tenor and Fee input into where belongs in the spreadsheet and I want that cell to tell me what gets spit out of another cell. Any suggestions?

Thanks

 

[yee388]

I want the table, in each box to insert its respective Tenor and Fee input into where belongs in the spreadsheet and I want that cell to tell me what gets spit out of another cell.

This is the part that confuses me. What's in "another cell"?

It sounds like a good situation for a Pivot table, but I'd like to see an example of 1) what you have and 2) what you'd like to see.