I want to be able to search for multiple criteria and copy and paste the rows into a new worksheet. I have an example of what I need as a vba code but this example only does it for one worksheet how do I apply it to multiple worksheet tabs on a file so that it searches for criteria all across the worksheets. Here is the example:
www.mrexcel.com
Find and return multiple value from a worksheet to another worksheet and move to next search criteria
Hi, I've been trying to find a way to look up a value from a list and return all entries from another worksheet, and when it's found it will move to another search criteria and repeat the same. Tried to use the index - array and small function but it will only return the first search criteria...
