Search results for query: *

Austin: Thanks for your suggestion. Unfortunately, I am designing this as a deliverable for some of the internal customers, and the issue with access is that yu need to have the application to run any queries. Unfortunately, not everybody has Access on its computer, so I might stick to Excel...

I am working in designing a query tool for a flat file, and want to get any suggestions. I have a database spreadsheet with three fields, say country, product and sales. And I want to show summarized tables of this data. Is there a straight forward way to do this using combo boxes? I know about...

Not possible. Functions won't execute any actions modifying the spreadsheets. The only way is with a subroutine, as shown by joerd below.

You can do as follows: dim r as range, arr() arr=selection r.value=arr() 'In this one, I am not sure, and you may have to do a For-Next loop to refill the data into the range