Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. folk754

    Querying database in Excel

    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...
  2. folk754

    Querying database in 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...
  3. folk754

    Trick a function to perform an action?

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

    transfer of array variables into a range

    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

Part and Inventory Search

Back
Top