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. QualityEngr

    Creating A Database And Using The Data For Project Quotes

    shearstrength, We can still use a combobox from the Control Toolbox (vs. Forms) that can include multiple columns. I am not entirely satisfied yet with the aesthetics, but since this is new territory for me, I am optimistic that we can make it work for you. I am willing to walk you through...
  2. QualityEngr

    Creating A Database And Using The Data For Project Quotes

    shearstrength, I did some searching on the web for the means to accomplish what you want. So far, I have found numerous requests for help for this very same problem, but no solutions. I am sure it can be done, but I am not sure yet how it can be done SIMPLY. As an alternative, I don't...
  3. QualityEngr

    Sorting data in same way as explorer

    Chunky, FYI - Excel's sorting rules are included in the Microsoft Knowledge Base article: XL2000: Sorting Alphanumeric Text as Numeric Values http://support.microsoft.com/default.aspx?scid=kb;en-us;214282&Product=xlw2K Text and numbers are sorted differently, which is why I am curious about...
  4. QualityEngr

    Sorting data in same way as explorer

    chunky, Are you trying to sort these filenames by date? If yes, are the dates in a column separate from the filenames? If yes, are they formated as dates or as text?
  5. QualityEngr

    Creating A Database And Using The Data For Project Quotes

    Shearstrength, Not knowing what your experience level is, it would take too long for me to explain the entire process in its simpliest terms. However, we can try a few steps at a time, and see where it leads us. You should run with it as far as you can on your own, but advise if you run into...
  6. QualityEngr

    Creating A Database And Using The Data For Project Quotes

    shearstrength, I think I know for what you are looking, if, in fact, you are still looking! You can use a combobox on your Quotesheet to present a list of parts on your Master: Input Range: specify the Master column in which your components are listed. Cell Link: specify a working cell, that...
  7. QualityEngr

    Creating A Database And Using The Data For Project Quotes

    shearstrength: Do you want to be able to enter the name of a component and have your program lookup its unit price? other information? Or are you just looking for a dropdown menu type solution, so you can select from the menu without typing, or mis-typing, the discription of the component...
  8. QualityEngr

    Call to run macro when shett activated?

    Denial, Can you give more detail for the VB-illiterates like me? Where does Worksheet_Activate() go? Is it part of the macro, or does it call the macro? Thanks.
  9. QualityEngr

    Is there any way to filter columns on Excel like filtering rows?

    mjcole: Use Paste Special to transpose columns and rows, filter, then transpose back.0
  10. QualityEngr

    Excel Links

    rnordquest: You do not need to get involved in VB programming to do what (I believe) you wanted. Simply type in the formula: =SUM( then select all the worksheets with the G2 cell you want to sum [your formual will show the range of worksheets. You can easily select a range of worksheets...

Part and Inventory Search

Back
Top