This project has moved and is read-only. For the latest updates, please go here.

How to filter a table based on another table cell value [Hyper link]

Dec 9, 2014 at 6:22 PM
Hi All,

I have 2 tables distributed in 2 different sheets for instance Sheet1 – Table 1 and Sheet 2 – Table 2, if I click on the cell ID in Table 1, I need to navigate to sheet 2 and filter the Table 2 based on ID value.

Sheet 1 Table 1
Sheet 2 Table 2

Please help me to identify the solution for this problem.

Kind regards,
Jayakumar A