First Excel Sheet
<tbody>
</tbody>
Second Excel Sheet
<tbody>
</tbody>
I have above two excel sheet.
The common column between these two excel sheet is "id"
What I want to do is
1. Filter based on Location in Sheet 2.
2. When I filter base on location in sheet 2 filter is automatically applied to sheet 1.
I need to keep both the sheet separate .
Thanks in advance. I am sql guy and new to excel
Id | Name | Dept |
1 | Jack | IT |
2 | Jill | HR |
3 | Mary | IT |
4 | Rosy | Payroll |
<tbody>
</tbody>
Second Excel Sheet
Id | Location |
1 | Melbourne |
2 | London |
3 | Melbourne |
<tbody>
</tbody>
I have above two excel sheet.
The common column between these two excel sheet is "id"
What I want to do is
1. Filter based on Location in Sheet 2.
2. When I filter base on location in sheet 2 filter is automatically applied to sheet 1.
I need to keep both the sheet separate .
Thanks in advance. I am sql guy and new to excel