Re: OFFSET function

Tech-Archive recommends: Speed Up your PC by fixing your registry

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" <Lynda@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:ED85EFB1-B8EC-4427-A7F8-5A0BE3C610B0@xxxxxxxxxxxxxxxx
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.
> *** 1 – Combo boxes (dropdowns) gets lists from *** 2. I have my > combo
> boxes attached to cells in *** 1.
>
> *** 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 *** 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
> *** 1 I chose ‘Apple’ which in my list on *** 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 *** in each survey > as
> this will be going to a large number of people and it will make > collating the
> data in a master *** 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.
>
> *** 1(dropdowns) *** 2(Lists) ***
> 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
>
.

Quantcast