Hi, Sorry if this has been answered before or is a very easy question but I did search the site and cannot find anything that makes sense to me, I have also tried different things myself. basically I have read only access to a 3rd party database holds all of my data, I have created a query that returns to excel a table of all the data I need (200 columns and 85000 rows) this is 1 year data and will get bigger, I need to present/report on this data but not at this size, is there anyway I can make the query bring back a date range as chosen by the user, say when I click refresh an input box comes up or set 2 x cells in the sheet with start and end then use that to run the query. Hopefully this all makes sense.