bsharath
asked on
Excel help to query few columns
Hi,
Desktop sheet "AP" has to match Temp sheet "A"
then
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
Attached file
Color all rows that were updated in desktop and temp sheet
Thanks
Movement--1-.xls
Desktop sheet "AP" has to match Temp sheet "A"
then
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
Attached file
Color all rows that were updated in desktop and temp sheet
Thanks
Movement--1-.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.