I want to pass values from one worksheet into parameters to get another sheet. Let me explain it clearly. I have 2 worksheets employee and organization. I have employee table and values in it . If i click on one value or number in the table the entire row (containing values) should show in parameters i have and that helps in getting data on sheet2. I am able to enter the values manually into parameters and get data. But i want the values to pass from sheet 1 to parameters on one click.
Thank you in Advance
we can use Parameters to filter data in view.
parameter will not perform what you asking for.