t0ny84
Board Regular
- Joined
- Jul 6, 2020
- Messages
- 205
- Office Version
- 365
- 2016
- 2013
- Platform
- Windows
- Mobile
- Web
Hi All,
I am wondering if anyone knows if the following is able to be done within Excel and if so how (preferably without a macro).
Excel Document includes 2 tables
tblStaffData - This includes everyone who works within a company's data, e.g. name, dob, employee id, etc.
tblTeam1 - This list needs to auto populate based upon the team name put next to a persons name in the tblStaffData table.
e.g.
tblStaffData -
Name John Smith
Team - Team 1
tblTeam1 would then show John Smith in that table, if his team was changed to Team 2 Excel would then remove him from Team 1 table and add him into Team 2 table.
I hope this makes sense as what I think in my head and what I want to say sometimes don't end up being the same. I do not currently have any demo\temp document I can upload to play around with as I haven't yet created this document I am just wanting to find out if it would be possible!
Thanks in Advance!
t0ny84
I am wondering if anyone knows if the following is able to be done within Excel and if so how (preferably without a macro).
Excel Document includes 2 tables
tblStaffData - This includes everyone who works within a company's data, e.g. name, dob, employee id, etc.
tblTeam1 - This list needs to auto populate based upon the team name put next to a persons name in the tblStaffData table.
e.g.
tblStaffData -
Name John Smith
Team - Team 1
tblTeam1 would then show John Smith in that table, if his team was changed to Team 2 Excel would then remove him from Team 1 table and add him into Team 2 table.
I hope this makes sense as what I think in my head and what I want to say sometimes don't end up being the same. I do not currently have any demo\temp document I can upload to play around with as I haven't yet created this document I am just wanting to find out if it would be possible!
Thanks in Advance!
t0ny84