Basically i have this script which compare 2 sheets, which compares a value in a column to the new sheet, if it finds the value, it will copy the information from Old sheet "B" to new sheet "B" column.
The script is working flawlessly (Thanks to the author)
I have trying to configure it to search and compare not only 1 column, but 2, if column X AND Y are equal to X AND Y in the new sheet it will do the same task.
The reason for this is that sometimes i have the value it searches for in few different rows, so when it compares it will find it at few places. While this script works perfect only when there are unique "Find" values.
Can you help me to edit so it fits "Find" and compare Column "P" & Column "V" if those are the same in new sheet, it will copy the Values in Column "B" old sheet to "B" new sheet.
So i need to tweak this to search both column P, AND Column V, if both are correct then it will do the comment merge, if something is wrong it will tell me what Tag is wrong.
The author told me this should be easy change, but for me it is not.
That should be a relatively easy change. In the Do Loop, you'd need to add a check for the value in the second column(s). If you get stuck on that, please start a new question (feel free to provide a link to this one) with what you've tried.
I got little help with this code, but it is not working properly.
It merges the comments to all which have the tag in P, so not correctly comparing P and V, also it is not giving me any fault anymore. But will post here maybe you get an idea.
Bookmarks