Hello Excel Gurus,
First time posting novice here trying to learn VBA. I have been trying to learn by reverse engineering all of great examples provided here. I am stuck and could not find a solution to the following task and any support would be greatly appreciated.
1. I have a workbook with multiple sheets, sheet 1 being the query output and the rest contain the data
2. I would like to click a button to initiate a text entry box where a person's name is entered (data in column B)
3. Any full or partial match will result in the adjacent (column C) being pasted in the output column A sheet 1
4. The associated sheet name (Person) is displayed in output column B sheet 1
5. It would be great to be able to reset the query sheet via a reset button so another name can be searched
I am attaching an example to try and demonstrate it better. The data relationship and distribution is similar to what I am encountering.
Thank you for your time.