Good Afternoon,
Previously I posted a thread and was advised to use names to match from one worksheet to another. Well, the top examples worked but not all are being highlighted. In the For Sale worksheet I have line 21 match in the Wanted worksheet line 6. You can see I've concatenated to make sure there were no extra spaces. Can anyone tell me why this isn't working?
Thanks again for all of your help!
Lori
It's because your named ranges only go down as far as row 5.
Update your named ranges to include all rows...currently they go to row 5 only.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Duh! Thanks for the help!
Lori
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks