Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy worksheets MJ Excel Discussion (Misc queries) 2 February 19th 09 01:31 AM
how do i copy a cell in worksheets 10 to the other 9 worksheets bete New Users to Excel 3 March 15th 07 10:41 AM
copy between worksheets does not copy formulae just values Chris@1000 Oaks Excel Discussion (Misc queries) 0 March 19th 06 11:44 AM
Worksheets won't copy Ted Excel Discussion (Misc queries) 0 June 1st 05 01:01 AM
Copy worksheets courtesio99[_17_] Excel Programming 5 January 1st 04 04:43 PM


All times are GMT +1. The time now is 09:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"