Dynamic Table

efrosen

New Member
Joined
Jul 19, 2005
Messages
9
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
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

yee388

Well-known Member
Joined
Mar 7, 2004
Messages
1,374
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,042
Messages
5,545,688
Members
410,698
Latest member
Wloven
Top