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...
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...
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
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?
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.