View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ZZBC[_2_] ZZBC[_2_] is offline
external usenet poster
 
Posts: 2
Default 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