copy values generated by conditional formula in one sheet to the other work sheet as values

Hi Everybody,


I have data generated by conditional formulae in work sheet1 in
columns A to J. If the condition is satisfied the cell will display a
realnumber, if the condition doesn't satisfied the cell will display
the text"FALSE".

Now I wanted to copy the cells which have the real numbers in
sheet1 to sheet2 as values(as we do with paste special and paste the
values) Do we have any formula or other method to copy the cells in
sheet1 to sheet2. can anybody helpme out in this issue.

Thanks and Regards

Ramana

You have a suggestion at your post in .misc

ramana wrote:
>
> Hi Everybody,
>
> I have data generated by conditional formulae in work sheet1 in
> columns A to J. If the condition is satisfied the cell will display a
> realnumber, if the condition doesn't satisfied the cell will display
> the text"FALSE".
>
> Now I wanted to copy the cells which have the real numbers in
> sheet1 to sheet2 as values(as we do with paste special and paste the
> values) Do we have any formula or other method to copy the cells in
> sheet1 to sheet2. can anybody helpme out in this issue.
>
> Thanks and Regards
>
> Ramana

--

Dave Peterson