Little confused. you have validation list in column Y in sheet called “total inforamtion”. You select any one of these cells choose one from the list for e.g Y5 and the activecell( Y5 ) value is “sheet2″– Y5 is the activecell. …
Read more:
Excel Movement