ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to Copy WorkSheets (https://www.excelbanter.com/excel-programming/352230-how-copy-worksheets.html)

ZZBC[_2_]

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



All times are GMT +1. The time now is 04:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com