Need to filter data in multiple sub-tables on of a sheet by separate header row
Good morning, all!
Normally, I would create a Database Program for this type of project, but - here we are.
BACKGROUND - We are an aircraft company that modifies existing aircraft. Each part of a modification is broken into individual MODULEs (MOD) following the aircraft Drawing Tree (system/included components/airframe location/etc.), each containing the numerous TASKS (step-by-step procedures, called TASK CARDS) required to accomplish each MOD. We currently have 9 aircraft in work, each with its own deviations to the overall MOD/TASK CARD structure.
PROBLEM - I have already created an Excel Workbook we use to track the status of all TASK CARDs assigned to each aircraft. The structure is as follows:
- 1 Workbook, containing 9 tabs (sheets), one for each aircraft
Each sheet is one table, made up of:
- 12 columns (Header), identifying the intended data for the column
- 83 bundled groups, of various quantities of rows, each representing one MOD and all the TASK CARDS for it
BUT - each MOD (bundled group) requires a 'MOD INFO' row (Sub-Header) with the MODULE NUMBER and TITLE to separate the TASK CARDS by MODULE.
As you can imagine, this has presented significant formatting clashes in 'single' large table form, as well as usability issues.
GOAL - To develop a more stable way to present each MOD (as its own Table?), where the data of the entire sheet (all MOD Tables) can still be filtered by the main HEADER row.
SO FAR - Using our current overall appearance and layout (everyone likes it), I have set each MOD as its own table, named to reflect that MOD (i.e., MOD_5_FJ), and have tried to then select all the MOD Tables and the HEADER ROW to then create a single table consisting of all the MOD Tables so I could use the filter row - hah, no such luck.
I am open to suggestions, and questions. I have included a sample of the current and my new worksheets, and an explanatory screen shot.
Thanks, in advance!
SnakeDoctor
|