Thread: Cell Value to Summary

Hi All,

Is there any way I can send cell values to a summary area on the same worksheet, ie:

I have built a little calculator, I would like to create a summary so I can show a series of results, without copying the formulas.

presently I am using a macro, eg:

cell B7 contains my result, my macro selects cell D7 , enters =B7 , copy D7 , then paste value into D7 , the macro also inserts rows, so as to create a list.

it works ok, but is a bit jerky, is there any way to simplify this, eg: macro send cell value (after insert row)

Thanks for any help.

Thanks, I was just wondering, I have been playing with it a bit more, and maybe this way is o.k. .. still would be interested if anyone can steer me in the right direction.

I am not sure if the summary cells could have formulas, as the calculator result cell changes with each calculation, the summary cells might still link to it.