[Lynda]

I was originally corresponding with Jim Cone in the General Questions area
but I think I frustrated him too much to return to me. I have decided to post
in the Functions area in case someone else can help me. Jim suggested that
the OFFSET function was what I needed to use to fix my problem. This is the
information I gave Jim for him to decide on the OFFSET function.
Sheet 1 €“ Combo boxes (dropdowns) gets lists from sheet 2. I have my combo
boxes attached to cells in sheet 1.

Sheet 2 €“ has my lists for the dropdowns

Sheet 3 €“ I want the cells in sheet3 to pick up the data from cells attached
the dropdown cells in sheet 1.

I can get A1(sheet3) to recognise the cell C5(sheet1) but it puts the number
of the cell from sheet2 instead of the text, eg In my combo box/dropdown on
sheet 1 I chose €˜Apple which in my list on sheet 2 would be B4. Instead of
showing Apple in Sheet3 it puts the number 4.
I am wanting to capture all the data on a separate sheet in each survey as
this will be going to a large number of people and it will make collating the
data in a master sheet much easier. I am using Excel 2003.
I was having a lot of trouble understanding how it works but I am determined
to work it out. I have been persisting at home with the problem I am having
with the function. I have managed to get most of them working, the ones I am
having trouble with now are those that are attached to a dependant drop down
list.

Sheet 1(dropdowns) Sheet 2(Lists) Sheet
3(Data)
D38 (got this one working) ColumnA G3
G38 (this one is dependent on D38) ColumnB H3
K38 (this one is dependent on G38) ColumnC I3

E44 (got this one working) Column O K3
H44 (this one is dependent on E44) Column P L3

Sorry for the long drawn out explanation and I hope it makes sense, I just
hope someone can help me.
Cheers
Lynda

[Eduardo]

Hi Lynda,
Look into Debra web has excellent examples

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

If this helps please click yes, thanks

"Lynda" wrote:

I was originally corresponding with Jim Cone in the General Questions area
but I think I frustrated him too much to return to me. I have decided to post
in the Functions area in case someone else can help me. Jim suggested that
the OFFSET function was what I needed to use to fix my problem. This is the
information I gave Jim for him to decide on the OFFSET function.
Sheet 1 €“ Combo boxes (dropdowns) gets lists from sheet 2. I have my combo
boxes attached to cells in sheet 1.

Sheet 2 €“ has my lists for the dropdowns

Sheet 3 €“ I want the cells in sheet3 to pick up the data from cells attached
the dropdown cells in sheet 1.

I can get A1(sheet3) to recognise the cell C5(sheet1) but it puts the number
of the cell from sheet2 instead of the text, eg In my combo box/dropdown on
sheet 1 I chose €˜Apple which in my list on sheet 2 would be B4. Instead of
showing Apple in Sheet3 it puts the number 4.
I am wanting to capture all the data on a separate sheet in each survey as
this will be going to a large number of people and it will make collating the
data in a master sheet much easier. I am using Excel 2003.
I was having a lot of trouble understanding how it works but I am determined
to work it out. I have been persisting at home with the problem I am having
with the function. I have managed to get most of them working, the ones I am
having trouble with now are those that are attached to a dependant drop down
list.

Sheet 1(dropdowns) Sheet 2(Lists) Sheet
3(Data)
D38 (got this one working) ColumnA G3
G38 (this one is dependent on D38) ColumnB H3
K38 (this one is dependent on G38) ColumnC I3

E44 (got this one working) Column O K3
H44 (this one is dependent on E44) Column P L3

Sorry for the long drawn out explanation and I hope it makes sense, I just
hope someone can help me.
Cheers
Lynda

[Lynda]

Hi Eduardo,

Thank you for your response. I am using Combo Boxes from the Forms Control
toolbar because i given VBE code for my dependant dropdown lists I am trying
to keep my sheets uniform by keeping with the same dropdown. I had a look
through Debra's page but it appears it is for data validation lists. This is
the code Jim Cone wrote for me =OFFSET(Sheet2!J1,'Sheet1'!G35-1,0,1,1). I
have managed to get it to work on all the dropdowns except the dependant
lists.

If you can help i would be grateful.
Cheers
Lynda



"Eduardo" wrote:

Hi Lynda,
Look into Debra web has excellent examples

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

If this helps please click yes, thanks

"Lynda" wrote:

I was originally corresponding with Jim Cone in the General Questions area
but I think I frustrated him too much to return to me. I have decided to post
in the Functions area in case someone else can help me. Jim suggested that
the OFFSET function was what I needed to use to fix my problem. This is the
information I gave Jim for him to decide on the OFFSET function.
Sheet 1 €“ Combo boxes (dropdowns) gets lists from sheet 2. I have my combo
boxes attached to cells in sheet 1.

Sheet 2 €“ has my lists for the dropdowns

Sheet 3 €“ I want the cells in sheet3 to pick up the data from cells attached
the dropdown cells in sheet 1.

I can get A1(sheet3) to recognise the cell C5(sheet1) but it puts the number
of the cell from sheet2 instead of the text, eg In my combo box/dropdown on
sheet 1 I chose €˜Apple which in my list on sheet 2 would be B4. Instead of
showing Apple in Sheet3 it puts the number 4.
I am wanting to capture all the data on a separate sheet in each survey as
this will be going to a large number of people and it will make collating the
data in a master sheet much easier. I am using Excel 2003.
I was having a lot of trouble understanding how it works but I am determined
to work it out. I have been persisting at home with the problem I am having
with the function. I have managed to get most of them working, the ones I am
having trouble with now are those that are attached to a dependant drop down
list.

Sheet 1(dropdowns) Sheet 2(Lists) Sheet
3(Data)
D38 (got this one working) ColumnA G3
G38 (this one is dependent on D38) ColumnB H3
K38 (this one is dependent on G38) ColumnC I3

E44 (got this one working) Column O K3
H44 (this one is dependent on E44) Column P L3

Sorry for the long drawn out explanation and I hope it makes sense, I just
hope someone can help me.
Cheers
Lynda

[Roger Govier[_3_]]

Hi Lynda

Take a look at the page I wrote and the sample downloadable file, for
creating dependent dropdown lists using Data Validation.
You can find it on Debra's site here
http://www.contextures.com/xlDataVal15.html

--
Regards
Roger Govier

"Lynda" wrote in message
...
Hi Eduardo,

Thank you for your response. I am using Combo Boxes from the Forms Control
toolbar because i given VBE code for my dependant dropdown lists I am
trying
to keep my sheets uniform by keeping with the same dropdown. I had a look
through Debra's page but it appears it is for data validation lists. This
is
the code Jim Cone wrote for me =OFFSET(Sheet2!J1,'Sheet1'!G35-1,0,1,1). I
have managed to get it to work on all the dropdowns except the dependant
lists.

If you can help i would be grateful.
Cheers
Lynda



"Eduardo" wrote:

Hi Lynda,
Look into Debra web has excellent examples

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

If this helps please click yes, thanks

"Lynda" wrote:

I was originally corresponding with Jim Cone in the General Questions
area
but I think I frustrated him too much to return to me. I have decided
to post
in the Functions area in case someone else can help me. Jim suggested
that
the OFFSET function was what I needed to use to fix my problem. This is
the
information I gave Jim for him to decide on the OFFSET function.
Sheet 1 €“ Combo boxes (dropdowns) gets lists from sheet 2. I have my
combo
boxes attached to cells in sheet 1.

Sheet 2 €“ has my lists for the dropdowns

Sheet 3 €“ I want the cells in sheet3 to pick up the data from cells
attached
the dropdown cells in sheet 1.

I can get A1(sheet3) to recognise the cell C5(sheet1) but it puts the
number
of the cell from sheet2 instead of the text, eg In my combo
box/dropdown on
sheet 1 I chose €˜Apple which in my list on sheet 2 would be B4.
Instead of
showing Apple in Sheet3 it puts the number 4.
I am wanting to capture all the data on a separate sheet in each survey
as
this will be going to a large number of people and it will make
collating the
data in a master sheet much easier. I am using Excel 2003.
I was having a lot of trouble understanding how it works but I am
determined
to work it out. I have been persisting at home with the problem I am
having
with the function. I have managed to get most of them working, the ones
I am
having trouble with now are those that are attached to a dependant drop
down
list.

Sheet 1(dropdowns) Sheet 2(Lists) Sheet
3(Data)
D38 (got this one working) ColumnA G3
G38 (this one is dependent on D38) ColumnB
H3
K38 (this one is dependent on G38) ColumnC I3

E44 (got this one working) Column O K3
H44 (this one is dependent on E44) Column P
L3

Sorry for the long drawn out explanation and I hope it makes sense, I
just
hope someone can help me.
Cheers
Lynda