| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move one cell to another
I need to copy the content of one cell to another when a different cell is
greater than 239. Example: if N20 is greater than R20(value 239) then copy the content of B20 to S20. OR A method to delete all records that have a value less than 240 in column N. Any help would be appreciated. Thanks, Mike -- Mike |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Move one cell to another
Formula in S20: =IF(N20R20,B20,"")
best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Mike" wrote in message ... I need to copy the content of one cell to another when a different cell is greater than 239. Example: if N20 is greater than R20(value 239) then copy the content of B20 to S20. OR A method to delete all records that have a value less than 240 in column N. Any help would be appreciated. Thanks, Mike -- Mike |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Move one cell to another
VBA Subroutine
Sub TryMe() 'Deletes rows where the value in column N is less than 240 Dim RowNdx As Long Dim LastRow As Long LastRow = Cells(Rows.Count, "N").End(xlUp).Row For RowNdx = LastRow To 1 Step -1 If Cells(RowNdx, "N").Value < 240 Then Rows(RowNdx).Delete End If Next RowNdx End Sub best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Mike" wrote in message ... I need to copy the content of one cell to another when a different cell is greater than 239. Example: if N20 is greater than R20(value 239) then copy the content of B20 to S20. OR A method to delete all records that have a value less than 240 in column N. Any help would be appreciated. Thanks, Mike -- Mike |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Move one cell to another
Thanks, this worked great..........................
-- Mike "Bernard Liengme" wrote: Formula in S20: =IF(N20R20,B20,"") best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Mike" wrote in message ... I need to copy the content of one cell to another when a different cell is greater than 239. Example: if N20 is greater than R20(value 239) then copy the content of B20 to S20. OR A method to delete all records that have a value less than 240 in column N. Any help would be appreciated. Thanks, Mike -- Mike . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Move one cell to another
This also worked great,,,,,,,,,,,,,,thanks again
-- Mike "Bernard Liengme" wrote: VBA Subroutine Sub TryMe() 'Deletes rows where the value in column N is less than 240 Dim RowNdx As Long Dim LastRow As Long LastRow = Cells(Rows.Count, "N").End(xlUp).Row For RowNdx = LastRow To 1 Step -1 If Cells(RowNdx, "N").Value < 240 Then Rows(RowNdx).Delete End If Next RowNdx End Sub best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Mike" wrote in message ... I need to copy the content of one cell to another when a different cell is greater than 239. Example: if N20 is greater than R20(value 239) then copy the content of B20 to S20. OR A method to delete all records that have a value less than 240 in column N. Any help would be appreciated. Thanks, Mike -- Mike . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I move from cell A 10 to cell B1 with one move or click | Excel Worksheet Functions | |||
| Arrow keys move screen instead of moving from cell to cell | Excel Discussion (Misc queries) | |||
| formula, move to previous cell when the current cell=0 or empty | Excel Discussion (Misc queries) | |||
| The absolute referenced cell does not move when source cell moves | Excel Worksheet Functions | |||
| Arrow keys move screen instead of moving from cell to cell. | Setting up and Configuration of Excel | |||
Linear Mode
