Clicking on Cell on one sheet and seeing the details on another sheet

[howard]

I have set up management accounts on sheet "Man_ACCTS". I have an account called general expenses in Col A and the total value in Col B.

I have the breakdown of all the general expenses on sheet TB and have named these "Gen_Expenses"

I would like the user to be able to double click on General expenses on sheet "Man_ACCNTS" and to be able to see what makes up this account on sheet TB

Your assistance in guiding me in the right direction is most appreciated.

 

[howard]

Thanks very much for the help and patience in getting the matter resolved. Code works perfectly now