Replace a cell value or leave what was alread
Closed
jimparker65
-
Nov 21, 2009 at 04:36 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 21, 2009 at 08:27 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 21, 2009 at 08:27 PM
Related:
- Replace a cell value or leave what was alread
- Why does facebook refresh when i leave the app - Guide
- Clear only the formatting from the selected cell (leaving the content) - Guide
- If cell contains date then return value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
- An example of a cell is a blank cell ✓ - Programming Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 21, 2009 at 08:27 PM
Nov 21, 2009 at 08:27 PM
this needa macro(which is given below and can be modified to suit you)
KEEP THE DATA SAFELY SOMEWHERE SO THAT IT CAN BE RETRIEVED IF NECESSARY
KEEP THE DATA SAFELY SOMEWHERE SO THAT IT CAN BE RETRIEVED IF NECESSARY
Sub test() If Range("B6") > Range("B11") Then Range("b11") = Range("B6") End If End Sub