| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto generate invoices | Excel Worksheet Functions | |||
| Auto Generate Sorting table(empty cell)?? | Excel Discussion (Misc queries) | |||
| Auto Generate Sorting table?? | Excel Discussion (Misc queries) | |||
| Auto generate email | Excel Discussion (Misc queries) | |||
| Generate Auto Order Number | Excel Discussion (Misc queries) | |||
Hybrid Mode
