View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Larry Fitch Larry Fitch is offline
external usenet poster
 
Posts: 24
Default 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