Hi,
I have a list of names in worksheet1
I have a Page for each name in Worksheet2
I need to creat a dropdown list in worksheet2 of names in worksheet1 which
will allow me to jump to his specific page.

how do i do this?

Thanks,
Jared

Hi,

Since you used the term "drop down list," I would like to highlight the
following links. However, the purpose is for data entry/validation. I am
not surprised if your approach may have to be something very different - a
formula/procedure plus hyperlink? I'll let the experts fill in the blank.

http://office.microsoft.com/en-us/as...022151033.aspx

http://support.microsoft.com/default...b;en-us;211548


Please note that I had to use INDIRECT() in the case of referencing a
**different** workbook (as per the second link above).

Thank you for the question and I am sure I can learn something here.

Epinn

"Jared" wrote in message
...
Hi,
I have a list of names in worksheet1
I have a Page for each name in Worksheet2
I need to creat a dropdown list in worksheet2 of names in worksheet1 which
will allow me to jump to his specific page.

how do i do this?

Thanks,
Jared

Epinn,

I looked through both links, but i couldn't figure out exactly what
exactly was i suppose to see in the pages. The first link got me through the
list, but the second link i did not understand at all how was connected to my
situation

thanks

"Epinn" wrote:

Hi,

Since you used the term "drop down list," I would like to highlight the
following links. However, the purpose is for data entry/validation. I am
not surprised if your approach may have to be something very different - a
formula/procedure plus hyperlink? I'll let the experts fill in the blank.

http://office.microsoft.com/en-us/as...022151033.aspx

http://support.microsoft.com/default...b;en-us;211548


Please note that I had to use INDIRECT() in the case of referencing a
**different** workbook (as per the second link above).

Thank you for the question and I am sure I can learn something here.

Epinn

"Jared" wrote in message
...
Hi,
I have a list of names in worksheet1
I have a Page for each name in Worksheet2
I need to creat a dropdown list in worksheet2 of names in worksheet1 which
will allow me to jump to his specific page.

how do i do this?

Thanks,
Jared

Jared,

Shall I say the second link is a continuation of the first link. If your
list of valid entries is in a **different workbook** and you follow the
instructions from link 1, you may get an error message "You may not use
references to other worksheets or workbooks for Data Validation criteria."
I did and I had to do a get around by using the instructions in link 2. It
may not be obvious to you until you try it. As I said in my first post, I
had to use INDIRECT() which was the second method stated in link 2.
Depending on your arrangement, you may or may not need link 2 for the fix.
I included it just in case.

Please look at link 1 and link 2 as part I and part II. If link 1 doesn't
help you at all, you can ignore link 2. You can also forget about link 2,
if you use ONE worksheet and not two workbooks.

I included the links for your reference as you mentioned drop down list.
That's all.

Epinn

"Jared" wrote in message
...
Epinn,

I looked through both links, but i couldn't figure out exactly what
exactly was i suppose to see in the pages. The first link got me through
the
list, but the second link i did not understand at all how was connected to
my
situation

thanks

"Epinn" wrote:

Hi,

Since you used the term "drop down list," I would like to highlight the
following links. However, the purpose is for data entry/validation. I
am
not surprised if your approach may have to be something very different -
a
formula/procedure plus hyperlink? I'll let the experts fill in the
blank.

http://office.microsoft.com/en-us/as...022151033.aspx

http://support.microsoft.com/default...b;en-us;211548


Please note that I had to use INDIRECT() in the case of referencing a
**different** workbook (as per the second link above).

Thank you for the question and I am sure I can learn something here.

Epinn

"Jared" wrote in message
...
Hi,
I have a list of names in worksheet1
I have a Page for each name in Worksheet2
I need to creat a dropdown list in worksheet2 of names in worksheet1
which
will allow me to jump to his specific page.

how do i do this?

Thanks,
Jared

Epinn,
Okay, the first link got me through making the list i needed, but how do
i add a hyper link per name? so clicking the name will get me to a specific
cell. but each name needs to be to a different location. i might need to add
a event click in vba, but i don't know how to add this to a list.

thanks
Jared

"Epinn" wrote:

Jared,

Shall I say the second link is a continuation of the first link. If your
list of valid entries is in a **different workbook** and you follow the
instructions from link 1, you may get an error message "You may not use
references to other worksheets or workbooks for Data Validation criteria."
I did and I had to do a get around by using the instructions in link 2. It
may not be obvious to you until you try it. As I said in my first post, I
had to use INDIRECT() which was the second method stated in link 2.
Depending on your arrangement, you may or may not need link 2 for the fix.
I included it just in case.

Please look at link 1 and link 2 as part I and part II. If link 1 doesn't
help you at all, you can ignore link 2. You can also forget about link 2,
if you use ONE worksheet and not two workbooks.

I included the links for your reference as you mentioned drop down list.
That's all.

Epinn

"Jared" wrote in message
...
Epinn,

I looked through both links, but i couldn't figure out exactly what
exactly was i suppose to see in the pages. The first link got me through
the
list, but the second link i did not understand at all how was connected to
my
situation

thanks

"Epinn" wrote:

Hi,

Since you used the term "drop down list," I would like to highlight the
following links. However, the purpose is for data entry/validation. I
am
not surprised if your approach may have to be something very different -
a
formula/procedure plus hyperlink? I'll let the experts fill in the
blank.

http://office.microsoft.com/en-us/as...022151033.aspx

http://support.microsoft.com/default...b;en-us;211548


Please note that I had to use INDIRECT() in the case of referencing a
**different** workbook (as per the second link above).

Thank you for the question and I am sure I can learn something here.

Epinn

"Jared" wrote in message
...
Hi,
I have a list of names in worksheet1
I have a Page for each name in Worksheet2
I need to creat a dropdown list in worksheet2 of names in worksheet1
which
will allow me to jump to his specific page.

how do i do this?

Thanks,
Jared

Jared

Do you have the ranges named in InsertName Define?

You could use event code with the DV list in B1

Option Compare Text
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Me.Range("B1")) Is Nothing Then Exit Sub
On Error GoTo endit
Application.EnableEvents = False
Select Case Target.Value
Case "peter"
Application.Goto Reference:="peter"
Case "paul"
Application.Goto Reference:="paul"
Case "mary"
Application.Goto Reference:="mary"
End Select
endit:
Application.EnableEvents = True
End Sub

If ranges are not named, just replace Application.Goto Reference:="peter" with

Sheets("Sheet2").Range("A1").Select

A lot of work if you have a great whack of names.


Gord Dibben MS Excel MVP


On Tue, 29 Aug 2006 11:22:02 -0700, Jared
wrote:

Epinn,
Okay, the first link got me through making the list i needed, but how do
i add a hyper link per name? so clicking the name will get me to a specific
cell. but each name needs to be to a different location. i might need to add
a event click in vba, but i don't know how to add this to a list.

thanks
Jared

"Epinn" wrote:

Jared,

Shall I say the second link is a continuation of the first link. If your
list of valid entries is in a **different workbook** and you follow the
instructions from link 1, you may get an error message "You may not use
references to other worksheets or workbooks for Data Validation criteria."
I did and I had to do a get around by using the instructions in link 2. It
may not be obvious to you until you try it. As I said in my first post, I
had to use INDIRECT() which was the second method stated in link 2.
Depending on your arrangement, you may or may not need link 2 for the fix.
I included it just in case.

Please look at link 1 and link 2 as part I and part II. If link 1 doesn't
help you at all, you can ignore link 2. You can also forget about link 2,
if you use ONE worksheet and not two workbooks.

I included the links for your reference as you mentioned drop down list.
That's all.

Epinn

"Jared" wrote in message
...
Epinn,

I looked through both links, but i couldn't figure out exactly what
exactly was i suppose to see in the pages. The first link got me through
the
list, but the second link i did not understand at all how was connected to
my
situation

thanks

"Epinn" wrote:

Hi,

Since you used the term "drop down list," I would like to highlight the
following links. However, the purpose is for data entry/validation. I
am
not surprised if your approach may have to be something very different -
a
formula/procedure plus hyperlink? I'll let the experts fill in the
blank.

http://office.microsoft.com/en-us/as...022151033.aspx

http://support.microsoft.com/default...b;en-us;211548


Please note that I had to use INDIRECT() in the case of referencing a
**different** workbook (as per the second link above).

Thank you for the question and I am sure I can learn something here.

Epinn

"Jared" wrote in message
...
Hi,
I have a list of names in worksheet1
I have a Page for each name in Worksheet2
I need to creat a dropdown list in worksheet2 of names in worksheet1
which
will allow me to jump to his specific page.

how do i do this?

Thanks,
Jared