Thank you for taking the time to help me I really appreciate it.
Basically I have multiple sheets and I need to be able to click on a cell and it will jump to a cell in another sheet. The cell that it jumps to will change because I am using a validation list and the data changes based on the validation. I have tried the hyperlink trick, but I don't know how to change the cell it jumps to based on the validation list. I hope that makes sense. I uploaded an example file that I hope will clarify things as well.
Thank you!!!
Bookmarks