| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF where values to be summed are formula | Excel Worksheet Functions | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
| Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
| Copy values from Sheet1 to Sheet2 | Excel Discussion (Misc queries) | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Linear Mode
