save a resualts calculation in one column

[ras-mir]

Dear members,

I have one problem for save and record for resualts of calculation on
formula in cells of one column.any time i repeat calculation, th
resualt save in first cell(link cell) and not move to below cell ,i
the other word ,i want for any calculation by formula resualts save i
next cell(without change of last try ).

Thanks
ras_mi

 

[Niek Otten]

Hi ras-mir,

Look at the Data>Table command

Here's a copy of links from Dick Kusleika

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

------------------------------------------------------------
Bill

Here are a couple of examples

http://www.dicks-blog.com/excel/2004/09/data_table_basi.html
http://www.dicks-blog.com/excel/2004/10/retail_pricing.html