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!

Recent content by BDNH

  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...
See more

Part and Inventory Search

Back
Top