How to find text in one worksheet in another workheet
Hi
I'm looking for the best way to see if a value in a specific cell on Sheet1 (eg: Sheet1!A1 has value of 12345) exists anywhere on Sheet2 (could be in any row/column in Sheet2!A:V). Ideally would like to return the position of where its found (eg: the cell J21).
Hopefully there is a somewhat easy way to do this!
Appreciate the help.
Please click the * Add Reputation if this helps
If solved remember to mark Thread as solved
"I'm glad to help and this is not meant to sound smart, but either you have super-human vision to see all those controls cleared one by one with the code I posted, or your computer is really slow."
Please Login or Register to view this content.
Sorry guys not sure what I did to cross post as I thought I only created one new post. I apologize.
It appears that some other site is scraping our questions. On closer inspection it looks like that site offers no way to respond to the posted question, and the page is serving as click-bait for ads. So there is no cross-posting violation here. Someone is stealing and republishing our content.
Thanks. When, I click on the link that is in the "you have a response" email it looks like your response is on how to remove brown spots!
Thanks for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks