Jump to drop-down selection on another sheet

[mrgillus]

http://www.excelforum.com/excel-prog...reedsheet.html

This is the original post.. and the original code was

Please Login or Register  to view this content.

This code works if your target is on the same sheet.. How would it be written if the location of the target was on a different sheet.. Let's just say Sheet 2 to make things simple..

[romperstomper]

Try this:

Please Login or Register  to view this content.

[mrgillus]

It doesn't appear to work... Here is the file..

[romperstomper]

Sorry, I missed a line and didn't see your underscore. It needs to be:

Please Login or Register  to view this content.

[Palmetto]

Try this:

Please Login or Register  to view this content.

[mrgillus]

Thanks Romp! That will do the trick.