Hello Everyone!!
I have three excel files as shown below,
| Department A |
| ID | Part No | Ser. No | Description | Issue | Solution |
| 2153 | 10154865 | ASD251 | Screw | Dimension | Scrap/ Rework |
| 2148 | 10158693 | AWS248 | Flange | Wear | Blast & Paint |
| Department B |
| ID | Part No | Ser. No | Description | Issue | Solution |
| 2218 | 10154865 | AWS271 | Sling | Certification | recertify |
| 2148 | 10158693 | AWS248 | Flange | Paint peel off | Paint touchup |
| Department C |
| ID | Part No | Ser. No | Description | Issue | Solution |
| 2148 | 10158693 | AWS248 | Flange | Surface finish | Rework |
| 2218 | 10154865 | AWS271 | Sling | Certification | recertify |
Now, I need to merge these tables and create new excel sheet to be used as a repository. Say, the master excel sheet should have provision for search bar to search for the column header. For eg., if I search for flange, it should automatically pull the three rows of data from Dep A, B and C to be displayed in my master sheet.
Is there a way to do it? or I need to create an interface for this
Thanks
