Hi! I am a complete newbie to Excel VBA. What I want to is conceptually simple but I am looking for code help. I have a table that calculates values of a table and generates a final result in one cell. There is ONE VARIABLE which is of type "Percentage". What I want to do is to generate automatically a TABLE that creates the RESULTS of the Output cell when I range my INPUT cell from 5% to 30% for example. Right now, I am changing it manually and then recording the result manually in a separate table.

Ideally I want to be able to run a macro that changes the INPUT cell (%age values) based on a given range and then autogenerates the corresponding table for me on a new worksheet.

Any help will be much appreciated!