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
Click to expand...
 

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

Similar Threads

copy values generated by conditional formula in one sheet to the other work sheet as values 1
If function across sheets prints value of cell 4
Copy addition formula of non-consecutive horizontal cells 2
how to copy and paste value from one sheet to another 4
Duplicating cell values from one sheet to another 3
Copy unformatted value of cell via macro 0
Excel 2010 Conditional Formatting 2
Populating a Text Field with a value in an Excel Sheet 0

Top