if i have a macro which run and give the output in sheet 1 then how can i write a macro which will do the calculation from the sheet 1 and give the output on sheet 2.

Please give me some suggestions.