MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Alan Ifft on December 07, 2001 1:29 PM

I want to use to criteria to select certain rows from a worksheet and have them automatically copied into another worksheet in the same workbook. I tried using Microsoft Query, but when I choose the Excel workbook it errors telling me the data source has no visible tables.
Any help you can give me would be greatly appreciated.

Posted by sdimaggio on December 08, 2001 7:58 PM

learn how to use the advanced filter under Data, filter, advanced filter. you will want to click, "copy to another location. in the list range highlight your database. in the criteria range highlight your criteria. then extract to the copy to range