Frank Freese
asked on
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?
In Access we can create a subform to the main form. In Excel can we create a sub-spreadsheet to a spreadsheet?
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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
ASKER
Regarding the camera tool - it represents only a snap shot of data - can you enter data?
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks folks - I appreciate your help