ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Related sub-grids in Excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/185546-related-sub-grids-excel-2003-a.html)

joel

Related sub-grids in Excel 2003
 
I am trying to find a way to display related information to a rather large
spreadsheet.

Each row in this spreadsheet has related information that I want to display
in a sub-grid under the selected row. MS Access 2003 does something very
close to what I want to do using the concept of 'Relationships' between
tables.

For each record in the main Excel grid, I want the user to be able to click
a button. Under the currently selected row, a grid/form will display showing
the related information.

I am attempting to create a template for our field consultants to specify
program level access for end users. I cannot write the template/app in MS
Access because the consultants do not have MS Access on their laptops.

I have searched the help file and the internet, but I have not found a
solution. Does Excel 2003 have this feature? If not, are there any
alternatives I can use?



All times are GMT +1. The time now is 03:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com