When I delete a row from sheet A I want the same row be deleted in sheet B

[odiseus]

I have a workbook with 10 sheets. When I delete one row (any row - each time i choose which one to delete) in sheet A I would like the same row to be automatically deleted from sheet B. How can this be done?
TIA

 

[lrobbo314]

If you are on sheet A, then hold shift and click on sheet B to select both sheets. Then delete the row you want to be gone and it will do it on both sheets.

 

[odiseus]

If you are on sheet A, then hold shift and click on sheet B to select both sheets. Then delete the row you want to be gone and it will do it on both sheets.

Thanks! That does it. I will try to transform this into a macro.

 

[odiseus]

Thanks! That does it. I will try to transform this into a macro.

 

[lrobbo314]

How about this?

Private Sub Worksheet_Change(ByVal Target As Range)
Dim r As Range
Set r = Selection
If Selection.Columns.Count = ActiveSheet.Columns.Count Then
    Dim ws As Worksheet
        For Each ws In ActiveWorkbook.Worksheets
            If ws.Name <> "Sheet1" Then
                ws.Range(r.Address).EntireRow.Delete
            End If
        Next ws
End If
        
End Sub

substitute sheet1 for sheeta or whatever your main sheet is named.

 

[odiseus]

Thanks much again!
I am much less sophisticated...

Code:

Sub Macro1()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+g
'
Sheets(Array("A", "B")).Select
Sheets("A").Activate
ActiveCell.EntireRow.Select
Selection.Delete
End Sub