Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy sheet cells into differnt workbook/sheet, How? | Excel Discussion (Misc queries) | |||
Copy a Sheet from one Workbook to another | Excel Discussion (Misc queries) | |||
Copy a Sheet from one Workbook to another | Excel Discussion (Misc queries) | |||
Copy a Sheet from one Workbook to another | Excel Discussion (Misc queries) | |||
Copy sheet to new workbook | Excel Discussion (Misc queries) |