View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DaveFinn DaveFinn is offline
external usenet poster
 
Posts: 12
Default Iteration funtion

Hi.

I have a workbook with lots of different sheets. The main idea is that you
input data on the first sheet, the middle ones use that input for different
kind of calculations and the result comes to final sheet.

I would like to make the process iterative so that it would go through
different inputs one at a time and place them in new result cells. The
purpose is to make sensitivity analysis with values like
0,50*input
0,75*input
1,25*input
1,50*input...

So how to make an iterative process to handle this? And if I need to use
VBA, where to out the code?

Please...