Hello,
I have a spreadhseet that has an excess of 30,000 rows (information about housing stock) and I want my users to be able to specify the criteria they require so they only see the rows of information relevant to them. Normally 10-20 out of the 30,000+.
I have used MS Query to successfully manipulate the data and return the required results on a new worksheet, but my end users are non-IT (case work) staff so I want to provide them with a basic form for specifying the relevant criteria (as much or little as required) and a 'go' button to run the query. - The User form does part of this, but doesn't provide a printable list like MS Query does.
E.G.
Number of bedrooms = >2
Post Code = G13
Floor = <1
The crietria will change everytime someone uses the form, so a fixed query will not work. Is it possible to use VBA to create the form that will then run the query with the specified criteria?
I also have the added issue that the workbook needs to be protected to prevent changes, but with protection enabled I cannot start the Query Wizard.
I know I should (and I would prefer) to do this in MS Access, but for a number of reasons that is not an option. Also, I am hindered by still (!) using Office 2003...
Any and all help will be gratefully appreciated!
Bookmarks