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


--
KatyLady
------------------------------------------------------------------------
KatyLady's Profile: http://www.excelforum.com/member.php...o&userid=23841
View this thread: http://www.excelforum.com/showthread...hreadid=375089

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.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"KatyLady" wrote in
message ...

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


--
KatyLady
------------------------------------------------------------------------
KatyLady's Profile:
http://www.excelforum.com/member.php...o&userid=23841
View this thread: http://www.excelforum.com/showthread...hreadid=375089

KatyLady, See my comments below.


"KatyLady" wrote in
message ...

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.


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



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!

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


--
KatyLady

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

------------------------------------------------------------------------
KatyLady's Profile:
http://www.excelforum.com/member.php...o&userid=23841
View this thread: http://www.excelforum.com/showthread...hreadid=375089

PC.

Thanks for your help. See comments to your comments below in red.

PC Wrote:
KatyLady, See my comments below.


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



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.



When I did this, it still wants to go to the wrong cell next, it will
fill in cell =E2, =E3 instead of going down the column with =F1, I try
highlighting three cells going down the column to show the pattern and
then drag the corner it will give me =c4 instead of =D1 which would be
next. I think I am doing this totally wrong. Any suggestion?


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!

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.

How can I make the user change the description, next cell to match the
category before continuing through any other part of the worksheet?

I'm adding a question...Can I freeze panes going for a column instead
of going across a roll? If so, How?

Thanks for your help!

KL


--
KatyLady

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.

K, will send my email to you today. THANKS!
PC


------------------------------------------------------------------------
KatyLady's Profile:
http://www.excelforum.com/member.php...o&userid=23841
View this thread:
http://www.excelforum.com/showthread...hreadid=375089
[/color]


--
KatyLady
------------------------------------------------------------------------
KatyLady's Profile: http://www.excelforum.com/member.php...o&userid=23841
View this thread: http://www.excelforum.com/showthread...hreadid=375089

Thanks RD, sorry for the misunderstanding.

KL

Ragdyer Wrote:
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.
--
Regards,

RD


--
KatyLady
------------------------------------------------------------------------
KatyLady's Profile: http://www.excelforum.com/member.php...o&userid=23841
View this thread: http://www.excelforum.com/showthread...hreadid=375089

PC,

What is your email? :)


--
KatyLady
------------------------------------------------------------------------
KatyLady's Profile: http://www.excelforum.com/member.php...o&userid=23841
View this thread: http://www.excelforum.com/showthread...hreadid=375089

There are a couple of other files on my site that might help you with
the questions you've asked below.

1) There are instructions here for using a combobox to overlay a cell
with data validation:

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

2) You could use the OFFSET function. For example, in cell A3:

=OFFSET($A$1,0,ROW()-3)

and copy down.

3) There's a file here that uses cross dependent validation:

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

Under Data Validation, look for 'Cross Dependent Validation Lists'

KatyLady wrote:
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




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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


"KatyLady" wrote in
message ...

PC,

What is your email? :)


--
KatyLady
------------------------------------------------------------------------
KatyLady's Profile:
http://www.excelforum.com/member.php...o&userid=23841
View this thread: http://www.excelforum.com/showthread...hreadid=375089

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

Debra Dalgleish Wrote:
There are a couple of other files on my site that might help you with
the questions you've asked below.

1) There are instructions here for using a combobox to overlay a cell
with data validation:

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

2) You could use the OFFSET function. For example, in cell A3:

=OFFSET($A$1,0,ROW()-3)

and copy down.

3) There's a file here that uses cross dependent validation:

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

Under Data Validation, look for 'Cross Dependent Validation Lists'

KatyLady wrote:
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




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


--
KatyLady
------------------------------------------------------------------------
KatyLady's Profile: http://www.excelforum.com/member.php...o&userid=23841
View this thread: http://www.excelforum.com/showthread...hreadid=375089

Change to formula to: =OFFSET($A$1,0,(ROW()-3)*2)

KatyLady wrote:
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

Debra Dalgleish Wrote:

There are a couple of other files on my site that might help you with
the questions you've asked below.

1) There are instructions here for using a combobox to overlay a cell
with data validation:

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

2) You could use the OFFSET function. For example, in cell A3:

=OFFSET($A$1,0,ROW()-3)

and copy down.

3) There's a file here that uses cross dependent validation:

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

Under Data Validation, look for 'Cross Dependent Validation Lists'

KatyLady wrote:

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




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

Debra Dalgleish Wrote:
Change to formula to: =OFFSET($A$1,0,(ROW()-3)*2)

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


--
KatyLady
------------------------------------------------------------------------
KatyLady's Profile: http://www.excelforum.com/member.php...o&userid=23841
View this thread: http://www.excelforum.com/showthread...hreadid=375089

You're welcome! Good luck with the order form.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


"KatyLady" wrote:


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

Debra Dalgleish Wrote:
Change to formula to: =OFFSET($A$1,0,(ROW()-3)*2)

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


--
KatyLady
------------------------------------------------------------------------
KatyLady's Profile: http://www.excelforum.com/member.php...o&userid=23841
View this thread: http://www.excelforum.com/showthread...hreadid=375089