If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I build a workbook from the worksheets another workbook?
Is it possible to make up the sheets of an Excel workbook from another
workbook that is in a remote address (i.e. a folder below) |
#2
|
|||
|
|||
If you're asking whether you can copy (or move) those sheets from that remote
workbook into another workbook, then the answer is yes. If you're asking if a workbook can contain worksheets of another workbook, then the answer is no. Rico wrote: Is it possible to make up the sheets of an Excel workbook from another workbook that is in a remote address (i.e. a folder below) -- Dave Peterson |
#3
|
|||
|
|||
Thanks Dave, I know you can populate cells from cells in another sheet within
the same workbook. Is it possible to do the same from workbook to workbook? Can a cell in a workbook be referenced to populate a cell in another workbook? Hope this makes the question clearer. Regards Rico "Dave Peterson" wrote: If you're asking whether you can copy (or move) those sheets from that remote workbook into another workbook, then the answer is yes. If you're asking if a workbook can contain worksheets of another workbook, then the answer is no. Rico wrote: Is it possible to make up the sheets of an Excel workbook from another workbook that is in a remote address (i.e. a folder below) -- Dave Peterson |
#4
|
|||
|
|||
yes
-- paul remove nospam for email addy! "Rico" wrote: Thanks Dave, I know you can populate cells from cells in another sheet within the same workbook. Is it possible to do the same from workbook to workbook? Can a cell in a workbook be referenced to populate a cell in another workbook? Hope this makes the question clearer. Regards Rico "Dave Peterson" wrote: If you're asking whether you can copy (or move) those sheets from that remote workbook into another workbook, then the answer is yes. If you're asking if a workbook can contain worksheets of another workbook, then the answer is no. Rico wrote: Is it possible to make up the sheets of an Excel workbook from another workbook that is in a remote address (i.e. a folder below) -- Dave Peterson |
#5
|
|||
|
|||
You can use a formula to "pull" the value from a different worksheet--and that
worksheet could be in the same workbook or a different workbook. Open two workbooks (book1.xls and book2.xls) in sheet1 of book1.xls, copy A1. in sheet1 of book2.xls, edit|paste special|paste link. You'll see the syntax for the formula. Close Book1.xls and watch what happens to that formula. ====== But if you're asking if you can change data in book1, book2, book3 and have book4 automatically be updated, the answer is yes--kind of.... You could have a macro that does all the work for you--but lots of things could go wrong. And it would be a pretty complex macro. You'd have to allow the user to make corrections. In fact, if they made 17 changes, then decided to close without saving, you'd have to be able to go back and fix your fixes. I surely wouldn't attempt this. Rico wrote: Thanks Dave, I know you can populate cells from cells in another sheet within the same workbook. Is it possible to do the same from workbook to workbook? Can a cell in a workbook be referenced to populate a cell in another workbook? Hope this makes the question clearer. Regards Rico "Dave Peterson" wrote: If you're asking whether you can copy (or move) those sheets from that remote workbook into another workbook, then the answer is yes. If you're asking if a workbook can contain worksheets of another workbook, then the answer is no. Rico wrote: Is it possible to make up the sheets of an Excel workbook from another workbook that is in a remote address (i.e. a folder below) -- Dave Peterson -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Appending external worksheets into existing workbook? | Xuratoth | Links and Linking | 1 | September 27th, 2005 12:52 AM |
Can I tile worksheets within a workbook, like one tiles workbooks. | Tovarish_Dad | General Discussion | 2 | July 6th, 2005 09:11 PM |
Worksheets in a workbook? | Bob .-.-. | New Users | 4 | June 23rd, 2005 10:30 PM |
How can I build a pivot table from multiple worksheets which are . | Richard Stephens | General Discussion | 2 | February 26th, 2005 10:04 PM |
Hyperlink to individual worksheets in same workbook | kgriffith | General Discussion | 5 | June 22nd, 2004 06:35 PM |