Excel codes
[Closed]
Report
Exceldummy
-
TrowaD
TrowaD
- Posts
- 2818
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- October 18, 2021
Related:
- Excel codes
- How to make a calculator in vba excel code - How-To - Excel
- Vba code to search data in excel - How-To - Excel
- Vba code to compare two excel sheets and copy differences ✓ - Forum - Excel
- Vba code to compare two excel sheets and highlight differences ✓ - Forum - Excel
- How to compare two Excel sheets with varying data ✓ - Forum - Excel
1 reply
TrowaD
- Posts
- 2818
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- October 18, 2021
Hi Exceldummy,
You mean like this:
To use the above, right-click sheet1's tab and select 'View code'. Paste the code in the big white field. Now make sure your destination sheet is called 'Sheet2' and type 'March' in column A of sheet1 and see what happens.
Best regards,
Trowa
You mean like this:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Columns("A")) Is Nothing Then Exit Sub
If Target.Value = "March" Then
Target.EntireRow.Copy _
Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
End If
End Sub
To use the above, right-click sheet1's tab and select 'View code'. Paste the code in the big white field. Now make sure your destination sheet is called 'Sheet2' and type 'March' in column A of sheet1 and see what happens.
Best regards,
Trowa
