Solved

Sub Form in Excel

Posted on 2011-03-03
8
1,287 Views
Last Modified: 2012-05-11
Experts,
In Access we can create a subform to the main form. In Excel can we create a sub-spreadsheet to a spreadsheet?
0
Comment
Question by:Frank Freese
  • 3
  • 3
  • 2
8 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35027206
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
 
LVL 12

Assisted Solution

by:sstampf
sstampf earned 250 total points
ID: 35027221
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
 
LVL 12

Assisted Solution

by:sstampf
sstampf earned 250 total points
ID: 35027244
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

Author Comment

by:Frank Freese
ID: 35027297
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
 

Author Comment

by:Frank Freese
ID: 35027328
Regarding the camera tool - it represents only a snap shot of data - can you enter data?
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35027341
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
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 250 total points
ID: 35027412
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
 

Author Closing Comment

by:Frank Freese
ID: 35027752
thanks folks - I appreciate your help
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question