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