Can I convert a whole worksheet into a function?

I have a spreadsheet with 2 tabs. Tab 1 cell A1 I enter the profit and cell D45 displays the result (a figure based on a comination of tax etc). Tab 2 column A I have a list of profits levels, column B is the result from D45 for each profit level. At the moment I have to go to Tab 1, type each profit into box A1, note the result in D45, switch to Tab 2 and type the D45 result into Column B. Is there a way I can turn Tab 1 into a function so that excel will automatically put each profit figure from Tab 2 Column A into Tab 1 cell A1 and then automatically put the result in Tab 2 Column B?

Comments
There are 5 comments. Login or register to view them.

Either

ACDWebb |
ACDWebb's picture

Data tables?

shurst |
shurst's picture

Data Table will work

edhy |

Forgive me if I am

DazedByTheLight |
DazedByTheLight's picture

It is Simple

edhy |