I have a list of items in column A of Sheet1 and the same list in column A of Sheet2. Both list will contain the same items, however not necessarily in the same order.
What I want the book to do is; when I click on an item in the list on Sheet1, it takes me to the same item in Sheet2.
Is this possible with VBA?
Bookmarks