Thread: Macro that can run a formula from another tab with variables

All,
I need help creating a macros using a formula on another spreadsheet. I built a table in one spreadsheet that has an input cell and fills out the table according to whatever variable is entered (formulas are build into each cell of the table). On another spreadsheet, same workbook, I have a column of variables that I would like to run through the table and get information for. In the end I would like to copy the values of one column of the table, for each variable, and transpose it to a row and paste it next to the variable. I have a lot of variables and find it would be easier to try and build a macros instead of manually running all the numbers and copy and pasting the values. Thanks guys.

Where's the workbook? And shouldn't this be in the programming forum?