Auto Generate Table
 

Hi! I am a complete newbie to Excel VBA. What I want to is conceptuall
simple but I am looking for code help. I have a table that calculate
values of a table and generates a final result in one cell. There i
ONE VARIABLE which is of type "Percentage". What I want to do is t
generate automatically a TABLE that creates the RESULTS of the Outpu
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
separate table.

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

Any help will be much appreciated

--
techtsunam
-----------------------------------------------------------------------
techtsunami's Profile: http://www.excelforum.com/member.php...fo&userid=3265
View this thread: http://www.excelforum.com/showthread.php?threadid=52466