How To Copy a Sheet to Another workbook
 

Hi! excell programmers,
I need ur help very urgent.

Problem1:
I have three different excel documents[in different
locations] and both contain a portion of the same data.
If i make changes to workbook1, the changes must appear to
workbook 2&3.

Lets say cell rage a20:k20 is the same for both workbooks,
If i make changes to workbook1 for range a20:k20 then the
changes must also appear in workbook 2&3 in range a20:k20.
I hope i made myself clear. Your help it is very
appreciated.
Problem2:
How do you copy the whole sheet to another sheet[in
another excel workbook] using a macro?



Thanks

How To Copy a Sheet to Another workbook
 

Question 2 is simple...just add this code to a macro and run it:

Sheets("YourSheetYouWantToCopy").Cop
Befo=Workbooks("YourFileToCopyTo").Sheets("Shee tYouWantToPasteItBefore")


or Use the After option to paste it After some specified sheet

As for Question 1, what do you want to be your "Event" tripper. Wil
you click a button when you are done or do you want those other file
updated automatically

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

How To Copy a Sheet to Another workbook
 

Problem 1:

I'd suggest having one of the sheets as the master
document, then link the cells in the other workbooks to
this master. Copy the range from the master sheet, then
use Paste Special - Paste Link to set up the link in the
two other workbooks.

Now uncheck the 'Ask to update automatic links' option in
Tools/Options/Edit.

Cheers,
Dave
-----Original Message-----
Hi! excell programmers,
I need ur help very urgent.

Problem1:
I have three different excel documents[in different
locations] and both contain a portion of the same data.
If i make changes to workbook1, the changes must appear
to
workbook 2&3.

Lets say cell rage a20:k20 is the same for both
workbooks,
If i make changes to workbook1 for range a20:k20 then the
changes must also appear in workbook 2&3 in range a20:k20.
I hope i made myself clear. Your help it is very
appreciated.
Problem2:
How do you copy the whole sheet to another sheet[in
another excel workbook] using a macro?



Thanks

.