Hi,
I've trying to build a reporting system in Excel, so that a list of client names is expandable. Once you click on a Client name (Simiar to clicking a parent folder in windows) then a list of projects/jobs is displayed in the next column, and when a project/list is selected, then the detail of that project/job is displayed. the trouble is, when i create a group, when it is collapsed, the first row dissapears from view with it. Is there any way so that when a group is collapsed, the first row stays visible?
I've trying to build a reporting system in Excel, so that a list of client names is expandable. Once you click on a Client name (Simiar to clicking a parent folder in windows) then a list of projects/jobs is displayed in the next column, and when a project/list is selected, then the detail of that project/job is displayed. the trouble is, when i create a group, when it is collapsed, the first row dissapears from view with it. Is there any way so that when a group is collapsed, the first row stays visible?