Help With Macro

How to Create Data Table Excel?

Create a Table that has at least 2 columns. First column filled with test values and second column header with calculation to be tested.
Select this table range, then click menu -> Data -> What-If Analysis. It will have options for Scenario Manager, Goal Seek & Data Table. Now, a Pop will ask for Row Input Cell and Column Input Cell. Choose appropriate cells for Row or Column Input. Then click ok.