Sub Form in Excel

Experts,
In Access we can create a subform to the main form. In Excel can we create a sub-spreadsheet to a spreadsheet?
Frank FreeseAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rory ArchibaldConnect With a Mentor Commented:
No you can't enter data in the snapshot. Perhaps you would be better off simply opening a new window on the same workbook and leaving it set to your reconciliation area.
0
 
Rory ArchibaldCommented:
You can embed a spreadsheet in another spreadsheet, but it's not really the same thing. Why do you want a "subform" in a worksheet?
0
 
sstampfConnect With a Mentor Commented:
You can use the camera tool to create a similar effect. To learn about camera tool see:

http://www.whypad.com/posts/excel-tip-the-camera-tool-a-cool-view/160/

http://chandoo.org/wp/2008/12/02/excel-camera-tool-help/
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Frank FreeseAuthor Commented:
I used "subform" because it was the only label I could think of. Can an embeded spreadsheet (I'll call it the 'child") be called like a macro and linked to the "parent" spreadsheet?

Here's the need.

At the end of a period our "parent" spreadsheet is used to reconcile information against our corporate office. Within the "parent" spreadsheet is a section used for reconciliation. If we could call an embedded or "child" spreadsheet it would allow us to keep the "child" in front of the "parent", which has all the detail.
0
 
Frank FreeseAuthor Commented:
Regarding the camera tool - it represents only a snap shot of data - can you enter data?
0
 
Rory ArchibaldCommented:
If I understand you correctly, then no. There is no link between the two but you may be able to use the Camera tool suggested by sstampf.
0
 
Frank FreeseAuthor Commented:
thanks folks - I appreciate your help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.