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

R

ramana

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
 
D

Dave Peterson

You have a suggestion at your post in .misc
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top