I'm hoping someone can help me because I'm really stumped.
1) I have two workbooks (sample1 & sample2). I need to be able to compare values in column A on both sheets.
2) IF a value in column A for sample1 matches a value in column A in sample2 I need column B values in sample2 to replace existing column B values in sample1
3) I have other data in columns C&D in both samples but those need to stay unchanged.
Could someone please help? This would make my day!!
Thank you!
~S
Very easily done
Click on the button to run this macro
The two files must be open
Please Login or Register to view this content.
Last edited by mehmetcik; 12-18-2014 at 11:13 AM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks