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!

  • 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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
  4. BDNH

    I have a table that looks like this

    I have a table that looks like this. PC OD WT B36 12.000 STD B36 14.000 STD B36 12.000 STD B36 12.000 STD B36 12.000 STD B36 16.000 XS B36 16.000 XS B36 16.000 XS B36 16.000 XS B36 24.000 40 B36 24.000 40 B36 24.000 40 B36 24.000 40 B36 16.000 XS B36 16.000 XS I want the...
  5. BDNH

    I have used the record macro functi

    I have used the record macro function in Excel 97 to run an advanced filter. the macro runs fine with the quick key and when I click on the macro and hit run it also works fine. Can someone please tell me how to transfer this module to a command button to make running it easier?
  6. BDNH

    Advanced Filter Command Button

    Can someone give me an example VBA code to be able to use a command button to run an advanced filter in Excel 97. I dont know VBA so something I can cut and copy would be great. (I can set the data,criteria, and extract ranges) Also, if the extract range can be set to another sheet that would...
  7. BDNH

    COUNTIF - Using 2 columns or more ??

    I have read several questions similar to this one but I can't seem to solve my problem. I have a table of steel fittings that looks like this Size(in) WT(in) Type Description 10 0.250 45 ELL 10 0.500 90 ELL 24 0.500 TEE 12...

Part and Inventory Search

Back
Top