What you are asking for is fairly easy to set-up. You need to use the Sort
command to do what you are asking. For example, if your data was imported to
Sheet1, Cells A1 thru G50 and you wanted to sort by the A column you would
use the following command:

Range("A1:G50").Sort _
Key1:=Worksheets("Sheet1").Range("A1")

That will sort your data in ascending order based on your A column. If you
need more help with setting it up search in the Help file for Sort.
--
Mike
M2K Computer Consulting
www.m2kcomputers.com


"JB_Scheduler" wrote:

I import external data from an Access query into an Excel spreadsheet. Upon
refresh data I want to filter the imported records based on data from a
single cell in a separate worksheet in a separate workbook.
The data imported is employee information including days off requested and
has a date field. I am trying to get the query, when refreshed, to look in a
single cell located in a separate workbook and filter the records based on
the value of that cell.
I would like to attach the procedure/macro/code to a button and run on
click. I am a beginner at programming and wonder if this is possible? What is
the best way to go about it and open to suggestions to get me going in the
right direction. Thank You