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

B

bobby

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
 
R

Roger Govier

Hi Bobby

One way
Data>Filter>Autofilter select the drop down for the column and choose
Custom>Not Equal to >FALSE
This will exclude all the rows with False.
Copy the visible cells >Paste Special to your new sheet.

Regards

Roger Govier
 

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

Duplicating cell values from one sheet to another 3
copy values generated by conditional formula in one sheet to the other work sheet as values 1
Copy addition formula of non-consecutive horizontal cells 2
Conditional Formatting 1
.copy problems 4
Excel formula referencing cells 4
Copy unformatted value of cell via macro 0
Compare two different workbook sheet to show the difference in text 0

Top