needinghelp2765
New Member
- Joined
- Feb 8, 2022
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
Hi!
I am trying to create a personnel matrix for projects, that will auto-populate the contact details for each tab.
I have created a tab called 'contact list' where the data needs to pull from, a 'live jobs' tab that will act as the matrix to enter the data, and then individual tabs for the projects where I want the data to pull across to.
I am after some help with formulas and function, so if the tab is called 01 it will show in the corresponding cell (already set up), then the project name that corresponds with that number will be pulled across from the the 'live jobs', and then the contact details will be pulled across that correspond to the initials in the matrix.
Spreadsheet is available below.
Any advice would be most welcomed!
Cheers
I am trying to create a personnel matrix for projects, that will auto-populate the contact details for each tab.
I have created a tab called 'contact list' where the data needs to pull from, a 'live jobs' tab that will act as the matrix to enter the data, and then individual tabs for the projects where I want the data to pull across to.
I am after some help with formulas and function, so if the tab is called 01 it will show in the corresponding cell (already set up), then the project name that corresponds with that number will be pulled across from the the 'live jobs', and then the contact details will be pulled across that correspond to the initials in the matrix.
Spreadsheet is available below.
Any advice would be most welcomed!
Cheers
Dropbox - File Deleted - Simplify your life
www.dropbox.com