Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1844
  • Last Modified:

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?
0
Frank Freese
Asked:
Frank Freese
  • 3
  • 3
  • 2
3 Solutions
 
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
 
sstampfCommented:
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
 
sstampfCommented:
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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
 
Rory ArchibaldCommented:
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
 
Frank FreeseAuthor Commented:
thanks folks - I appreciate your help
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now