![]() |
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