Drop Downs, Index Match or what?

  • Thread starter Thread starter lhkittle
  • Start date Start date
Am Sun, 20 Oct 2013 19:32:21 -0700 (PDT) schrieb (e-mail address removed):
I tested every return and was able to repair a DuctIron 300 which did not exist and DuctIron 350 K9 returns #N/A. This might have been due to a typo on Helper Sheet with 350 K8 instead of K9. I changed everything I could find to K9 (pertaining to DuctIron 350) but no success.

GRP SN 10000 STIS refuses to work for me. Errors out on ant Dia. selected.

https://www.dropbox.com/s/g1b3a9re3di71a0/AA Copy of Drop Down Version two Drop Box.xlsm

Howard
Click to expand...


Regards
Claus B.
 
please look here:

https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3!326

for "Drop Down Version two"

There was a typo in the code

Instead of GRP there was GPR


Regards

Claus B.
Click to expand...


Well, I finished testing each possible return and all seem great!

I really appreciate ALL the help.

I like the reversed model you offered also. That may be a simpler solution or maybe use the two in combo, (meaning both available to consult, NOT as a combined unit.)

Regards,
Howard
 
Hi Howard,

Am Mon, 21 Oct 2013 02:32:18 -0700 (PDT) schrieb (e-mail address removed):
Well, I finished testing each possible return and all seem great!
Click to expand...

glad to help.
I like the reversed model you offered also. That may be a simpler solution or maybe use the two in combo, (meaning both available to consult, NOT as a combined unit.)
Click to expand...

Did you also look for "Drop Down Test"?


Regards
Claus B.
 
Hi Howard,



Am Mon, 21 Oct 2013 02:32:18 -0700 (PDT) schrieb (e-mail address removed):






glad to help.






Did you also look for "Drop Down Test"?





Regards

Claus B.
Click to expand...

Just now did, and that really looks like it should be of use.

Pretty clever. If I'm seeing it correctly you can start out with any one of the three items and then choose the other two from the choices it offers.

This really does have possibilities!

Thank, Claus.

Howard
 
Well, I finished testing each possible return and all seem great!

Hi Claus,

I am attempting to add an additional Material to the sheet and code.

So far I've added "Steel" to the drop down list.
I have added Steel, Dia., Class and ID to the Helper Sheet (all phony data for testing)
I have extended the Index formula range to row 530.

Every line in the code that I have added to try to make "Steel" work, is followed by '// so you can see where I have made the additions.

The code errors out here:

With Target.Offset(, 1).Validation...

with Formula1:=myStr

myStr = ""

Howard

Link to my test sheet:

https://www.dropbox.com/s/v0ffzlwrwsw2bfv/AAA Add Data Drop Down Mat. Dia. Class Drop Box.xlsm
 
Hi Howard,

Am Tue, 22 Oct 2013 10:48:05 -0700 (PDT) schrieb (e-mail address removed):
Yes, it does. That should help immensely.
Click to expand...

if you have strings like St 1, St2 then these strings have clear
indices. So you can put them in an array and call it by index.


Regards
Claus B.
 
if you have strings like St 1, St2 then these strings have clear

indices. So you can put them in an array and call it by index.
Click to expand...
Regards

Claus B.
Click to expand...

Okay, I did notice that it was called a bit different than the other Materials.

And now I am hung up on adding Copper, which I thought is the same as the original Materials, such as:

HDPe 50 PN 6.3 PE100
HDPe 50 PN 8 PE100

Copper 5 CP 1
Copper 5 CP 2

So I tried to just duplicate the workings of HDPe for Copper but again it errors out at the:

With Target.Offset(, 1).Validation...

with Formula1:=myStr

myStr = ""

I've marked all the added Copper code line I inserted with '/****

I'm trying to mark examples of how to add new materials for the future maintenance of the code.

So if the Helper Sheet format addition looks like the "Steel" addition then duplicate the code lines marked with '//.

And if the format looks like the "Copper" addition then duplicate the code lines marked with '/****.

It looks to me that these two Helper Sheet formats are all we are dealing with, is that true as you see it? (With Steel being the single exception to all the rest)

Link to my "Copper" addition attempt:

https://www.dropbox.com/s/bj5l8pbxpwfowxm/AAA Copper Add Data Drop Down Mat. Dia. Class.xlsm v1.xlsm

Howard
 
please look here:

https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3!326

for workbook "Copper"

Claus B.
Click to expand...

That works, as of course you already know.

The REVERSE Drop Down workbook was quite easy to add additional Materials.
And I noticed in the dependent DV drop down "refers to" Indirect formula using substitute so one is not bothered with spaces in the range names.

I think all is good to go, I thank you and sorry for all the spoon feeding I needed.

Regards,
Howard
 
..
never mind.

Where do you come from? You often ask while I am sleeping
Click to expand...
Regards

Claus B.
Click to expand...

I am in Eugene, Oregon USA.

And nice touch with the new photo, the red rock arch formation in the back ground looks a lot like a Park in the state of Utah not all that far from where I live.

Howard
 
Hi Howard,

Am Wed, 23 Oct 2013 02:13:24 -0700 (PDT) schrieb (e-mail address removed):
I am in Eugene, Oregon USA.
Click to expand...

so you are 8 hours later than I am
And nice touch with the new photo, the red rock arch formation in the back ground looks a lot like a Park in the state of Utah not all that far from where I live.
Click to expand...

That is the background of my profile in google+

The most useful table you can get is if you put the most important
criteria for choosing a product in column A. The second one in column B
and so on. Do you know the importance order of the criteria?


Regards
Claus B.
 
The most useful table you can get is if you put the most important

criteria for choosing a product in column A. The second one in column B

and so on. Do you know the importance order of the criteria?
Click to expand...

No, I do not. The general, theme as I understand it, is to assure a propermatch of Material, diameters (both inside and outside) to safely accommodate the nature of the fluid along with pressures and flow rates, with the last column supplying the cost per unit.

Howard
 
Hi Howard,

Am Wed, 23 Oct 2013 06:41:40 -0700 (PDT) schrieb (e-mail address removed):
No, I do not. The general, theme as I understand it, is to assure a proper match of Material, diameters (both inside and outside) to safely accommodate the nature of the fluid along with pressures and flow rates, with the last column supplying the cost per unit.
Click to expand...

then the ID will also be important.


Regards
Claus B.
 
Back
Top