Backend Data structuring for multiple tabs

Hello All,

I'm Slowly building a Personnel/Leave/Qualifications Tracker for my ship. Before I get further in this project I need to be sure the structure is valid. The attached file uses multiple sheets two of which (CREW_INFO & WEPS_QUALS) use a third sheet (ACT_MBR) for the data. I would like to know if the route I've chosen is poorly structured or should the supporting data for each CREW_INFO & WEPS_QUALS Tabs be separated. Eventually I want to archive members as they transfer so I don't want a "#REF" error on the WEP_QUALS sheet. Or would it or is it possible to move a member in the ACT_MBR to an INACT_MBR (Inactive Member) Sheet and a backend data sheet for the WEPS_QUALS Sheet. The Data on the WEPS_QUALS sheet will need to be presented on the WEPS_QUAL_RPTS sheet as well so I can create a readable/printable report.

I've be build this project based on a YouTube channel Excel For Freelancers by Randy Austin and the project is "Employee Manager Series".

Thank you in advance for your advice.

Jim

JeteMc,

Thank you for your advice.

I see you have added the formulas across the WEPS_QUALS on the on sheet "Weapons Quals" Tab but that is where my Data Entry takes place. Also would the Index/Match Formulas slow the application once I populated with the Crew Members (350+)? We only have Excel 2007 as well.

My goal is making the user interface simple to use. It amazes me how many different ways there are to build projects such as these. Beyond that I'm looking to add a filters on my WEPS_QUAL_RPT sheet such as well (Duty Section) and to identify members coming due for re-qualifications. But that will have to wait for another string when I get to that point.

Again, Thank you and your welcome. I do enjoy Japan and the Navy has had me here for over 5 years now.

V/r,

Jim

JeteMc,

Thank you for all of your time and expertise. I'm learning as I "poke in the dark" on different sections of this project as it gets built.

I'll test your formula and see if I can grasp how it works. My biggest problem is understanding formulas and how best to use/structure them.

Thank you for your efforts.

V/r,
Jim