Needs Function to "GO TO" certain cells from a Dropdown box

[Nadine Turton]

Hi - new on this site - posted this thread yesterday, received a reply but it was "closed" (?). What i actually need is any funtion (something like a hyperlink) that will "jump to" the designated cells when clicked on in the dropdown box. I have attached an extract from the original file - Sheet 'StockB', C1 is my dropdown box - currently it only highlights the text/cells when you click on a specific size, but you have to scroll down to see the appropriate information. i want it to jump to the text/cells if possible?

[Russell Dawson]

Hi Nadine - welcome to the forum.

This may be useful as it seems to do what you are asking for:

http://www.youtube.com/watch?v=p_77cZ1Vyl4

That said, it seems to me that a VLOOKUP would be useful. You don't state where you need to jump to and if it's selecting from a dropdown in "StockB" and jumping to the entry in that sheet a VLOOKUP would do.

Just a thought.

Cheers

Russell

[Nadine Turton]

Thanks Russell - The uploaded file doesnt look like it should. Stock B - C1 is a dropdownbox with a list created from SheetSize! When you click on the drop down arrow in Stock B-C1 it actually displays all the different sizes as on SheetSize. When you click on the size, it HIGHLITES the sizes on "Stock B" but then you have to scroll down to see the highlited part. (which the uploaded file also doesnt do anymore) I have now added a hyperlink in B1 (as in the link you gave me - even though mine doesnt work!) which should make it jump to the corresponding size in sheet "size". I have tried to alter it so that it would jump to the realted sizes on Sheet Stock B (as i dont need it to jump to a different sheet), but so far no luck. What i want it to do is when you click on the size in C1 (dropdown box) - sheet Stock B (or the hyperlink in B1), it should then directly jump to the highlighted sizes on sheet Stock B.