Select in drop down and automatically takes you to the worksheet
 

I'm using Prof. Excel 2003.

After selecting in a drop down a four digit number in a validation cell in
worksheet 1, I am attempting to have a direct 'link' to that number in
another worksheet 2 in the same workbook automatically.

Any suggestions?

Select in drop down and automatically takes you to the worksheet
 

Assuming the dropdown cell is Sheet1 A1

In A1 of Sheet2 enter =Sheet1!A1


Gord Dibben MS Excel MVP

On Wed, 13 Dec 2006 08:41:01 -0800, overmyhead
wrote:

I'm using Prof. Excel 2003.

After selecting in a drop down a four digit number in a validation cell in
worksheet 1, I am attempting to have a direct 'link' to that number in
another worksheet 2 in the same workbook automatically.

Any suggestions?

Select in drop down and automatically takes you to the workshe
 

Thanks Gord, but that isn't what I need done but my request was pretty lame.
Here is a better example:

What I need is for after entry of the 4 digit code, I need it to actually go
to that number located already in the workbook. So in Sheet 1 A1 I put
'1234', it links to the worksheet where '1234' is already listed (i.e. it
pops up the worksheet with that number I put in Sheet 1 A1).

I hope that explains it better. Thanks!

"Gord Dibben" wrote:

Assuming the dropdown cell is Sheet1 A1

In A1 of Sheet2 enter =Sheet1!A1


Gord Dibben MS Excel MVP

On Wed, 13 Dec 2006 08:41:01 -0800, overmyhead
wrote:

I'm using Prof. Excel 2003.

After selecting in a drop down a four digit number in a validation cell in
worksheet 1, I am attempting to have a direct 'link' to that number in
another worksheet 2 in the same workbook automatically.

Any suggestions?

Select in drop down and automatically takes you to the workshe
 

I mis-read the original.

Would Excel have to find where the value is on another sheet and go there?

Or do you have that cell named?

Are there multiple occurences of the value or unique?

How many different values are there to choose from in the DV list?

I think you would have to use change event code and some Case Selects to achieve
your ends.

More difficult if Excel has to go hunting for the value across multiple
worksheets.


Gord

On Wed, 13 Dec 2006 12:43:01 -0800, overmyhead
wrote:

Thanks Gord, but that isn't what I need done but my request was pretty lame.
Here is a better example:

What I need is for after entry of the 4 digit code, I need it to actually go
to that number located already in the workbook. So in Sheet 1 A1 I put
'1234', it links to the worksheet where '1234' is already listed (i.e. it
pops up the worksheet with that number I put in Sheet 1 A1).

I hope that explains it better. Thanks!

"Gord Dibben" wrote:

Assuming the dropdown cell is Sheet1 A1

In A1 of Sheet2 enter =Sheet1!A1


Gord Dibben MS Excel MVP

On Wed, 13 Dec 2006 08:41:01 -0800, overmyhead
wrote:

I'm using Prof. Excel 2003.

After selecting in a drop down a four digit number in a validation cell in
worksheet 1, I am attempting to have a direct 'link' to that number in
another worksheet 2 in the same workbook automatically.

Any suggestions?

Select in drop down and automatically takes you to the workshe
 

To answer your questions:

- Yes, Excel will have to find where the value is on another sheet and go
there but would specifically like it to go to the cell based on the value
selected (i.e. 1234 entered, and it goes to wkst and cell where 1234 is -
note there will only be 1234 which I believe addresses the next item).
- The Values are unique (all different).
- Around 30 different values from DV.



"Gord Dibben" wrote:

I mis-read the original.

Would Excel have to find where the value is on another sheet and go there?

Or do you have that cell named?

Are there multiple occurences of the value or unique?

How many different values are there to choose from in the DV list?

I think you would have to use change event code and some Case Selects to achieve
your ends.

More difficult if Excel has to go hunting for the value across multiple
worksheets.


Gord

On Wed, 13 Dec 2006 12:43:01 -0800, overmyhead
wrote:

Thanks Gord, but that isn't what I need done but my request was pretty lame.
Here is a better example:

What I need is for after entry of the 4 digit code, I need it to actually go
to that number located already in the workbook. So in Sheet 1 A1 I put
'1234', it links to the worksheet where '1234' is already listed (i.e. it
pops up the worksheet with that number I put in Sheet 1 A1).

I hope that explains it better. Thanks!

"Gord Dibben" wrote:

Assuming the dropdown cell is Sheet1 A1

In A1 of Sheet2 enter =Sheet1!A1


Gord Dibben MS Excel MVP

On Wed, 13 Dec 2006 08:41:01 -0800, overmyhead
wrote:

I'm using Prof. Excel 2003.

After selecting in a drop down a four digit number in a validation cell in
worksheet 1, I am attempting to have a direct 'link' to that number in
another worksheet 2 in the same workbook automatically.

Any suggestions?