Drop Downs, Index Match or what?

[Claus Busch]

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

Regards
Claus B.

 

[Claus Busch]

Hi Howard,

Am Sun, 20 Oct 2013 19:32:21 -0700 (PDT) schrieb (e-mail address removed):

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

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.

 

[lhkittle]

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.

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

 

[Claus Busch]

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!

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.)

Did you also look for "Drop Down Test"?


Regards
Claus B.

 

[lhkittle]

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.

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

 

[lhkittle]

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

 

[Claus Busch]

Hi Howard,

Am Tue, 22 Oct 2013 09:58:26 -0700 (PDT) schrieb (e-mail address removed):

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.

look here:
https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for workbook "AAA Data Drop Down"

It seems to work.

Regards
Claus B.

 

[lhkittle]

It seems to work.



Regards

Claus B.

Yes, it does. That should help immensely.

Thanks,
Howard

 

[Claus Busch]

Hi Howard,

Am Tue, 22 Oct 2013 10:48:05 -0700 (PDT) schrieb (e-mail address removed):

Yes, it does. That should help immensely.

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.

 

[lhkittle]

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.

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

 

[Claus Busch]

Hi Howard,

Am Tue, 22 Oct 2013 16:24:04 -0700 (PDT) schrieb (e-mail address removed):

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

please look here:
https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for workbook "Copper"


Regards
Claus B.

 

[lhkittle]

please look here:

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

for workbook "Copper"

Claus B.

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

 

[lhkittle]

..

never mind.

Where do you come from? You often ask while I am sleeping

Regards

Claus B.

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

 

[Claus Busch]

Hi Howard,

Am Wed, 23 Oct 2013 02:13:24 -0700 (PDT) schrieb (e-mail address removed):

I am in Eugene, Oregon USA.

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.

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.

 

[lhkittle]

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?

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

 

[Claus Busch]

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.

then the ID will also be important.


Regards
Claus B.

 

[lhkittle]

Hi Howard,



Am Wed, 23 Oct 2013 06:41:40 -0700 (PDT) schrieb (e-mail address removed):






then the ID will also be important.

Yes, I would expect so.

Howard