May 13, 2021
I have a problem, For better understanding of my problem I added sample sheet here.
Emp Information - Contains Employee basic Information Address, Phone Number, Which team he belongs to. C2:c13 is used to arranged Employee based on the Team.
Team will be changing daily, Team change Information will be manually Entered in Emp Information under Monday to Saturday.
Emp Individual Schedule - Information of the Each Employee with the TEAM CODE.
Team Schedule - TEAMS with CODES.
Employee Team Change Information needs to be updated only in Emp Information Automatically it should get Information from Team Schedule (CODES) and updated in Emp Individual Schedule.
For that I used INDEX & MATCH Formula.
In Emp Information Sheet, It need to be Shuffle the Information for Example : Information in Cell 12 can be copied and Entered in C14 and New Information can be added and deleted. it should reflect in Emp Individual Schedule Sheet.
Thank You in Advance.
February 13, 2021
You can basically copy cells using a formula, this is a new one I found a couple of months ago for a project of mine. You may want to extend it past your current rows to allow for growth, and making your "Employee Information" tab a table would also be helpful because as your list grows your named ranges will pick them up automatically. Hope this helps.
July 16, 2010
In Cell D2 of the Emp Individual Schedule sheet enter this formula:
=INDEX(Code, MATCH(INDEX('Emp Information '!I$2:I$30, MATCH('Emp Individual Schedule '!$B2,'Emp Information '!$B$2:$B$30,0)), Team_Name,0),COLUMNS($A:A))
Then copy to other cells in the table.