Search A List Of Values To See If They Appear Anywhere on Several Worksheets

jhgiants95

New Member
Joined
Jul 21, 2014
Messages
23
I am looking to see if a list of values (in a column) appears at all in several different workbooks that each contain about 15 worksheets. I know this is a lot of information to search through so I am a little concerned about performance issues but a macro may be the best solution rather than a formula.

Any feedback would be appreciated. Thanks in advance.
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

mumps

Well-known Member
Joined
Apr 11, 2012
Messages
9,552
Are all the workbooks to be searched open or do they have to be opened? If they have to be opened, what is the full path to the folder in which they are saved? Are they the only files in that folder? What is the name of the sheet that contains the list of values and in which column is that list? In the sheets to be searched, do you want to search the entire sheet or a specific column? Can a value occur more than once in any sheet? Once found, what do you want to do with the values?
 
Last edited:

jhgiants95

New Member
Joined
Jul 21, 2014
Messages
23
They have to be opened, I can fill in the file paths if you label where in the code/formula to put them. Thanks for the help.
 

mumps

Well-known Member
Joined
Apr 11, 2012
Messages
9,552
In order to suggest a working macro, I need answers to the questions I listed in my previous post.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,974
Messages
5,525,990
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top