Desktop sheet "AP" has to match Temp sheet "A"
Desktop sheet "L" match with temp sheet column "C"
If same then split the temp sheet colum "E" data into 3 parts and paste in desktop sheet
Yes as you said I want to split the temp sheet "E" into 3 parts and place them in "R,X,Y" columns
Color the rows on which have been updated with a color so i know what are the changes
The whole goal is match the employee id and machine name nd update the location of the users
Its a user database that i want to update
people have moved from one building to 4 other buildings
Hope this answers all your questions
else please buzz me will try to rephrase
Color all rows that were updated in desktop and temp sheet