Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim riga As Long If Target.Cells.CountLarge > 1 Then Exit Sub If Not Intersect(Target, Range("I21:I33")) Is Nothing And Target = "T" Then riga = Target.Row - 16 Application.EnableEvents = False Range(Range("F" & Target.Row), Range("I" & Target.Row)).Copy Range("F" & riga).PasteSpecial xlPasteAll 'Range("F" & Target.Row & ":H" & Target.Row) = Range("F" & riga & ":H" & riga).Value Application.EnableEvents = True End If End Sub
Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim riga As Long If Target.Cells.CountLarge > 1 Then Exit Sub If Not Intersect(Target, Range("I21:I33")) Is Nothing And Target = "T" Then riga = Target.Row - 16 Application.EnableEvents = False Range("F" & Target.Row & ":H" & Target.Row) = Range("F" & riga & ":H" & riga).Value Application.EnableEvents = True End If If Not Intersect(Target, Range("I5:I17")) Is Nothing And Target = "T" Then riga = Target.Row Application.EnableEvents = False Range("F" & Target.Row + 16 & ":H" & Target.Row + 16) = Range("F" & riga & ":H" & riga).Value Application.EnableEvents = True End If End Sub
Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim riga As Long If Target.Cells.CountLarge > 1 Then Exit Sub If Not Intersect(Target, Range("I5:I13", "I21:I33")) Is Nothing And Target = "T" Then Select Case Target.Row Case 5 To 13 riga = Target.Row + 16 Case 21 To 33 riga = Target.Row - 16 End Select Application.EnableEvents = False Range(Range("F" & Target.Row), Range("H" & Target.Row)).Copy Range("F" & riga).PasteSpecial xlPasteAll Application.EnableEvents = True End If End Sub
inserisco la " T " in I21 mi faccia un copia e incolla da H5 , G5 , F5 in H21 , G21 , F21 . La " T " in I6 copia e incolla da H6 , G6 , F6 in H22 , G22 , F22
aureliano74, 19/09/2023 11:11:ok grazie... ultima domanda , e se invece del copia e incolla dovesse essere copia collegamento? dove devo intervenire