Hi, I have a drop down box linked to cell A2 for example, when the change is made on the drop down box the linked cell returns the value 1,2or 3. I'm not sure if I require a code or an 'IF' command - but what I would like to achieve is that say when 2 is selected I want to goto sheet 3 A1, if 3 is selected then sheet 3 A2 and if 1 then nothing happens. Or can I make the function dependant on what the drop down box displays e.g Correct, Not Correct and Requires Change. (1,2 and 3 respectively)
Hope I make sense.
Many thanks
Chris
Bookmarks