Creating an Order Form....Ragdyer & anyone else?

K

KatyLady

I can't get back to my thread for some reason, and since it's your order
form Rag, I am hoping you or someone can help me again...

Here's the things I need to do and can't seem to figure it out...

1. On the drop down list, some of the description list are very long,
they have to sometimes choose 100 items, I would like the customer to
be able to type in a few letters and have the closest item come up...i
thought it was auto complete but must not be because it doesn't work
for me.

2. How do I make a column recognize the next pattern and complete it. I
haven't done this in ages and I have tried several ways but it wants to
go to the next cells as =A2 =A3 =A4 instead of F1 G1 H1 etc.

=A1
=B1
=C1
=D1
=E1


3. How can I make it where Column 1 if changed will clear out column 2
on the order form to start over, because if I select a different
category than previously selected, it will let me keep the wrong
description for that category unless i tab over and change it too.

An Example...

Selecting Category "pens" then description retractible, then change my
mind and decide to enter markers, it keeps retractable until I change
it, even though retractible is not an item for markers.

Thanks in advance! The order form looks awesome!

KL
 
R

Ragdyer

Just because I directed you to the link to Debra's website, doesn't mean
that all the goodies that you find there originated from me.<g>

It would be best for you to return to the site:

http://www.contextures.com/tiptech.html

And use the Contact e-mail address of Debra's, and see if she will answer
your questions in regard to her forms.
 
P

PC

KatyLady, See my comments below.


KatyLady said:
I can't get back to my thread for some reason, and since it's your order
form Rag, I am hoping you or someone can help me again...

Here's the things I need to do and can't seem to figure it out...

1. On the drop down list, some of the description list are very long,
they have to sometimes choose 100 items, I would like the customer to
be able to type in a few letters and have the closest item come up...i
thought it was auto complete but must not be because it doesn't work
for me.
Click to expand...

Katy, auto complete doesn't work on Data Validation Drop downs
2. How do I make a column recognize the next pattern and complete it. I
haven't done this in ages and I have tried several ways but it wants to
go to the next cells as =A2 =A3 =A4 instead of F1 G1 H1 etc.

=A1
=B1
=C1
=D1
=E1
Click to expand...

Two choices, one is to go into the Tools/Options/Edit and change the "Move
Selection After Enter" option to "Right" The other is to highlight the row
when entering each item.

3. How can I make it where Column 1 if changed will clear out column 2
on the order form to start over, because if I select a different
category than previously selected, it will let me keep the wrong
description for that category unless i tab over and change it too.

An Example...

Selecting Category "pens" then description retractible, then change my
mind and decide to enter markers, it keeps retractable until I change
it, even though retractible is not an item for markers.

Thanks in advance! The order form looks awesome!
Click to expand...

Even if you set it up so that the column 2 list is dependent on column 1 the
cell won't update automatically. Unless there is only one logical choice
for that column it will require some kind of user input to update the form.
KL
Click to expand...

If you e-mail me I can send you a copy of a search function I use to return
similar items from a list that the user can then select the exact item they
are seeking.

PC
 
P

PC

Katy

This should have my e-mail address.

I couldn't follow your last reply as I only read this newsgroup as text
without formatting.

PC
 
K

KatyLady

On # 2, it worked but can I also change this to reflect every other cell
in a roll...IE.,

Column going down to copy cells going across...

A1
C1
E1
G1
H1

Thanks, the order form is coming along but I have thousand of products
to copy and paste, and that is the biggest time consumer.

KL
 
D

Debra Dalgleish

Change to formula to: =OFFSET($A$1,0,(ROW()-3)*2)
On # 2, it worked but can I also change this to reflect every other cell
in a roll...IE.,

Column going down to copy cells going across...

A1
C1
E1
G1
H1

Thanks, the order form is coming along but I have thousand of products
to copy and paste, and that is the biggest time consumer.

KL
Click to expand...
 
K

KatyLady

Thanks!!! (oh gosh, I just can't say thanks on here, it requires 1
words. tehe) :)
 
Top