How to Copy WorkSheets
I am using the following code to copy 'just the values' from a current
worksheet ("Input") to another worksheet ("Output_5Tab") whenever
changes were made in the "Input" worksheet:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column < 1 Then Exit Sub
With Sheets("Output_5Tab")
.Range(Target.Address).Value = Target.Value
End With
End Sub
I would like to add additional code to also copy the entirety of the
'values' of Worksheet ("Int_1") to Worksheet ("Int_2") each time a
change is made to worksheet ("Input"). Both of the worksheets "Int_1"
and "Int_2" are fixed is size (40 rows and 2 columns), however they are
'merged' cells (each cell is actually 3 rows tall in both sheets).
I would appreciate any help
Bob
|