I am working on a database that has the potential to house LOTS of data (Individual Fish lengths from years of surveys). I currently have the workbook saved as a Macro-enabled so I know i have a little over 1 million rows to work with, but in time that will not be enough.... Is there a way to set the advanced filter feature to look through multiple worksheets? Or do I need to look at using an access database to house this.

Thanks!

Tyler