Under the "GL Info" worksheet, I have listed a series of account numbers under Column F.



Next to that column, column G, I started copying the account number and linking them to the "Detailed" worksheet where the account number is also listed and located.

Doing this seems to be tedious, and I would like to know if someone can help me with a macro so that when I click the account number in either Column F or Column G (under the GL Info worksheet), it link the account number to the same account number in the worksheet named "Detailed".

Thank you for your assistance and cooperation.

Cheers!!!

Attached Files

FY 16-Monthly Budget Variance Report Analysis-Test File.xlsx (266.2 KB, 11 views)