Forum

Notifications
Clear all

Automatic update of Information from One sheet to another sheet in One Excel (Addition and Deletion of Rows ).

3 Posts
3 Users
0 Reactions
78 Views
(@priyanka1)
Posts: 7
Active Member
Topic starter
 

Good Morning, 

                      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.

Requirement :
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.

Problem :
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. 

Priyanka Kumar

                     

 
Posted : 23/06/2021 6:43 am
(@jstewart)
Posts: 216
Estimable Member
 

Hi Priyanka,

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. Cool

 
Posted : 23/06/2021 10:43 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Priyanka,

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.

Mynda

 
Posted : 26/06/2021 10:28 pm
Share: