How do I build a workbook from the worksheets another workbook?

R

Rico

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)
 
D

Dave Peterson

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.
 
R

Rico

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
 
P

paul

yes
--
paul
remove nospam for email addy!



Rico said:
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
Click to expand...
 
D

Dave Peterson

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.
 
Top