ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can you embed a worksheet in another worksheet? (https://www.excelbanter.com/excel-discussion-misc-queries/153809-can-you-embed-worksheet-another-worksheet.html)

m1das

Can you embed a worksheet in another worksheet?
 
I would like to put a worksheet inside another worksheet. Anyone know how?
I have a bunch of data that is sorted chronologically and would like a small
area (independent of the main sheet) to show monthly totals at a glance.

squenson via OfficeKB.com

Can you embed a worksheet in another worksheet?
 
I guess you need to create a second file with your summary cells. Then in
Excel 2003, click on the menu Insert Object, then tab "Create from file"
and select the Excel file you want to embbed. This file can have some
references to the "container" file, so it will update each time you update
the main file.

Stephane Quenson

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200708/1



All times are GMT +1. The time now is 01:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com