Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy worksheets | Excel Discussion (Misc queries) | |||
how do i copy a cell in worksheets 10 to the other 9 worksheets | New Users to Excel | |||
copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
Worksheets won't copy | Excel Discussion (Misc queries) | |||
Copy worksheets | Excel Programming |