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

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