Database

%3CLINGO-SUB%20id%3D%22lingo-sub-1117418%22%20slang%3D%22en-US%22%3EDatabase%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1117418%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20building%20a%20database%20on%20excel%20for%20employees.%20I%20have%20created%207%20pages%20.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Epage%201%20main%20menu%20-%20shows%20how%20many%20employees%20and%20their%20ID%20numbers%20in%20a%20list%20.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Epages%202-7%20are%20the%20subcategories%2F%20departments%20which%20the%20employees%20work%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20assign%20each%20employee%20an%20ID%20number.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20that%20if%20i%20assign%20a%20number%20to%20an%20employee%20on%20page%205%20it%20can%20show%20up%20automatically%20on%20page%20one%20in%20the%20list%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20so%20-%20please%20can%20someone%20help%20me%20figure%20a%20formula%3F%20Thank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1117418%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1117467%22%20slang%3D%22en-US%22%3ERe%3A%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1117467%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F524948%22%20target%3D%22_blank%22%3E%40ardeeofficial%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20the%20ID%20already%20available%20on%20page%201%3F%20In%20that%20case%20you%20can%20use%20VLOOKUP%20or%20INDEX%20and%20MATCH.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1117530%22%20slang%3D%22en-US%22%3ERe%3A%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1117530%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F524948%22%20target%3D%22_blank%22%3E%40ardeeofficial%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20you%20are%20still%20developing%20your%20database%2C%20I%20would%20recommend%20you%20to%20divert%20from%20your%20plan%20to%20create%20one%20list%20per%20department.%20In%20stead%2C%20create%20one%20list%20of%20all%20your%20relevant%20employee%20information%20and%20include%20a%20column%20that%20holds%20the%20department.%20You%20can%20then%20easily%20create%20summaries%20(e.g.%20headcount%2C%20FTE%2C%20by%20business%20unit%2C%20by%20department%2C%20by%20gender)%2C%20similar%20to%20what%20you%20describe%20as%20what%20you%20have%20in%20your%20main%20menu.%20The%20best%20way%20would%20be%20to%20familiarise%20yourself%20with%20Pivot%20Tables%20and%20or%20Filters.%3C%2FP%3E%3C%2FLINGO-BODY%3E
ardeeofficial
Occasional Visitor

I'm building a database on excel for employees. I have created 7 pages . 

 

page 1 main menu - shows how many employees and their ID numbers in a list . 

 

pages 2-7 are the subcategories/ departments which the employees work 

We assign each employee an ID number.

 

Is it possible that if i assign a number to an employee on page 5 it can show up automatically on page one in the list?

 

If so - please can someone help me figure a formula? Thank you!

 

2 Replies
Highlighted

@ardeeofficial 

 

Is the ID already available on page 1? In that case you can use VLOOKUP or INDEX and MATCH.

Highlighted

@ardeeofficial 

Since you are still developing your database, I would recommend you to divert from your plan to create one list per department. In stead, create one list of all your relevant employee information and include a column that holds the department. You can then easily create summaries (e.g. headcount, FTE, by business unit, by department, by gender), similar to what you describe as what you have in your main menu. The best way would be to familiarise yourself with Pivot Tables and or Filters.

Related Conversations
Database Build or Template Help
TurningPoint in Access on
1 Replies
Creating a searchable database
Dan Blondeau in Microsoft 365 on
3 Replies
Updating front end servers database
craig taylor in Skype for Business IT Pro on
3 Replies