how to query a data range? Allen_N 6/21/2007 12:17:32 AM I would like to have a worksheet that displays the top 50 rows from another worksheet, based on values in a particular column. I've been doing this manually, but there must be a way to do it with SQL, or something, so I can just click 'Refresh'. Is there? Thanks!