How to automatically highlight cell in sheet 1 based on click in cell in sheet 2

[Rob11]

Hi, I have a problem. I'm actually not sure that it can be done in Excel (MS Office 2016) but I have a row of symbols on sheet 1 and a column of symbols on sheet 2. I'd like to format the workbook so that any time I click on a cell in the column on sheet 2, Excel automatically flips back to sheet 1 and highlights the cell with the corresponding value. Sort of like making "Search" function automatic: without copying the cell value from sheet 2, flipping back to sheet 1, going Ctrl+F and pasting the symbol in the search window.
BTW, I meant to attach my Excel file but the "Attachments" button above doesn't seem to be doing anything...

[Kaper]

This could be achieved for instance with such a code for sheet 2 (right click on sheet2 tab, and select "display code", then paste the code, close VBA editor window and remember to save your workbook in macro enabled format (for instance xlsm).

Please Login or Register  to view this content.

see attached file

[Rob11]

Thanks a million - it works like a dream