VBA Code for matching cell data in the column and taking nearby cell data
Hello,
I have two files, file 1 and file 2. In both the files data are different except name of the employees. I want to match name of the employees in both the files and extract score of that employee in the next column so that score of that employee will be exactly next to that employee name (as given in result file). For better understanding sample files are attached. Please provide VBA code. Thank you.
Do you want the desired result from File 1 and File 2 in a new third file?
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Anything, it will be fine even if result will be in the new sheet or in new file.Originally Posted by Mumps1
Make sure that both files are open. Place this macro in File2. Change the file name (in red) and sheet names (in blue) to suit your needs. Run the macro.
b
Please Login or Register to view this content.
If both files are open...
Place this code in File 2 and run...
If variable rowPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by sintek; 08-09-2021 at 03:45 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks