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
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

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.
 

Forum statistics

Threads
1,141,670
Messages
5,707,730
Members
421,525
Latest member
carian1980

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top