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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: BDNH
  • Order by date
  1. BDNH

    Drop down list Determined By Cell Value

    Thanks Skip Looks like just what I'm looking for
  2. BDNH

    Drop down list Determined By Cell Value

    Me again Can I make a drop down list that is based on a cell value? On Sheet 1 I use a Drop down list in cell U5 to choose the nominal Outside Diameter (OD) of the pipe I want to work with. On Sheet 2 In Cell A8 I have a VLOOKUP formula that returns the physical OD of the pipe. I want a drop...
  3. BDNH

    Object Size Linked to Cell Imput

    Sorry - didnt see your last post b4 posting mine - How do I give you a star?
  4. BDNH

    Object Size Linked to Cell Imput

    NM - I got It Thank you so much - works great!
  5. BDNH

    Object Size Linked to Cell Imput

    K - Im back from lunch :) Thanks for your patience - I no nothing about VBA - can I just copy and paste your code into a module then asign it to a button to get the desired results? or do I need to do something else?
  6. BDNH

    Object Size Linked to Cell Imput

    Thanks for your help. Actually I would like the dimensions of the circle to be dependent on value that is imput into cell B1 then generate a circle at 1/10 scale. Therefore if I imput 12.750" into cell B1 - the button will generate a 1.275" circle (same as height and width 1.275) The value in...
  7. BDNH

    Object Size Linked to Cell Imput

    Yes I know - You cant just specify the diameter 12.750" (same as height 12.750" and width 12.750") and have the button generate a 1.275" circle?
  8. BDNH

    Object Size Linked to Cell Imput

    Thanks for the quick reply. Not sure that this answers your qustion but here goes. I just want to be able to specify the diameter of the circle to be generated. the placement on the sheet is not that critical. I can easily drag it to the location i need it. For arguments sake lets say that cell...
  9. BDNH

    Object Size Linked to Cell Imput

    Sorry - I had height and width on my mind when I said 2 cells. I guess what I really need is to be able to specify the diameter of the pipe i.e. 12.750" and then have the macro button create a circle 1.275" (1/10 scale)
  10. BDNH

    Object Size Linked to Cell Imput

    Hello everyone! Is there a way to make the size (height and width) of a autoshape - - namely a circle dependent on the imput of 2 cells? I would like to be able to visualize how many pipes (of different diameters) could be loaded into an ocean container. I would like to draw a square...
  11. BDNH

    Extracting Unique Values

    Thank you all for your responses. Dale – I am sending you an example of what I need – thanks Ken – I am always grateful for the help received on Tek-Tips by the people who take time to answer questions from the desperate people like myself. Please don’t take my repeated insistence personally...
  12. BDNH

    Extracting Unique Values

    If this can't be easily done will someone please let me know thanks
  13. BDNH

    Extracting Unique Values

    Anyone?
  14. BDNH

    Extracting Unique Values

    I still have not been able to figure this out. Is this possible without copy and pasting the columns manually?
  15. BDNH

    Extracting Unique Values

    Thanks for both your replies Ken - In the example I gave the data range is small. What if in another situation it is a large range? Is there any way to create a named range with many columns, filter it, and extract all the unique values to one column? acron - I tried the advanced filter but it...
  16. BDNH

    Extracting Unique Values

    How can I extract unique values from a given range that includes more than 1 column. For example, I need to extract all the unique values in H2:K31 there are some empty cells is this range. I need to list the extracted values in 1 column. can someone give me some ideas please. Thanks
  17. BDNH

    Advanced Filter Command Button

    acron, just wanted to let you know that I tried this again and it worked great! I Don't know what I was doing wrong before --- again, thanks for your help BDNH
  18. BDNH

    I have a table that looks like this

    Zathras I've become real busy and didn’t want you to think that I was ignoring you or was ungrateful. As soon as I can try your VLOOKUP (probably Monday) I'll let you know how it went Thanks again
  19. BDNH

    I have a table that looks like this

    Zathras, Here is my situation, These are just 3 columns of information inside a larger table. These particular columns refer to Piping Class (PC) Outside Diameter (OD) and Wall Thickness (WT) The piping class refers to a set of construction parameters specified by the client. In this example...
  20. BDNH

    Advanced Filter Command Button

    KLMorgan Good points, I will sure keep them in mind. As I've said before All comments and help are welcome. Thanks BDNH

Part and Inventory Search

Back
Top