Madhan
12/12/2006 3:11:00 PM
Hi, in Sheet2, you should write a VBA macro to use the values present in
Sheet1 and then at the end of computation copy the value to the required cell
in Sheet1.
"Horatiu" wrote:
> Hi all,
>
> I'm having some problems trying to create a function to perform the
> computations on a different sheet. i.e. I have 2 columns in sheet1,
> each pair on a row representing input into sheet2 where extensive
> computations are taking place. The final result in sheet2 (for each
> pair in sheet1) I want to return it in sheet1 (column 3). Any
> suggestions how to do it?
>
> Thx,
> -horatiu-
>
>