Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert a subdatasheet in Excel, like Access
I know in Access you can show a table and a subdatasheet's corresponding
values by expanding the row, but I am wondering if there is a way to also do this in Excel. I am using Office 2003, SP3. Thank you for all your help, this site is AWESOME!!!!! -- Sue |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert a subdatasheet in Excel, like Access
The closest thing that you can get to in Excel is using the DATA/SUBTOTALS
function to genrate a list of grouped totals/counts/averages/etc. To accomplish this you would sort your table on the column you're grouping on and the click DATA/SUBTOTALS from the menu. In the dialog box select the column you're grouping on in the first combo box, in the second combobox select the statistical function you want to perform, and in the third filed check the field(s) you want to apply the function to. -- Kevin Backmann "SP" wrote: I know in Access you can show a table and a subdatasheet's corresponding values by expanding the row, but I am wondering if there is a way to also do this in Excel. I am using Office 2003, SP3. Thank you for all your help, this site is AWESOME!!!!! -- Sue |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert a drop down list into an excel cell, linked to Access | Excel Worksheet Functions | |||
Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
Access Form In An Access Report (SubForm) Question | Links and Linking in Excel | |||
How do I insert an image in Access from a linked Excel spreadshee. | Excel Discussion (Misc queries) | |||
export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) |