Ah yes, it's including partial matches, so it matches "NY" with "CompaNY" :D
Easy to fix - change this line:
![]()
Set c = wsTgt.Range("1:1").Find(what:=v, lookat:=xlWhole)
Ah yes, it's including partial matches, so it matches "NY" with "CompaNY" :D
Easy to fix - change this line:
![]()
Set c = wsTgt.Range("1:1").Find(what:=v, lookat:=xlWhole)
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks