Creating a new worksheet from non zero values
 

I want to be able to take the results of formulas from one worksheet and move
them to a new output sheet... The logic I would like to follow is -

If values of certain cells are greater than zero, then move those cells as
well as the formulas that created them to a new sheet..

What I am hoping to do is eliminate the need to manually delete any formulas
that I do not want to use in my final calculations.

and to put the icing on the cake, I would like to be able to have a "button"
of some sort on the calculation sheet that would invoke the programming to
move everything..
--
Thanks

Larry

Creating a new worksheet from non zero values
 

Larry,

"What I am hoping to do is eliminate the need to manually delete any formulas
that I do not want to use in my final calculations. "

Why not write your final formulas to ignore cells that are zero or lower?

HTH,
Bernie
MS Excel MVP


"Larry Fitch" wrote in message
...
I want to be able to take the results of formulas from one worksheet and move
them to a new output sheet... The logic I would like to follow is -

If values of certain cells are greater than zero, then move those cells as
well as the formulas that created them to a new sheet..

What I am hoping to do is eliminate the need to manually delete any formulas
that I do not want to use in my final calculations.

and to put the icing on the cake, I would like to be able to have a "button"
of some sort on the calculation sheet that would invoke the programming to
move everything..
--
Thanks

Larry