Hi,
I am relatively new to VBA and would like to request for your kind help.
This is what I would like to do:
1. Given a search term eg: ABC (Name)
2. Search all worksheets in the workbook under the Name column that contains 'ABC'
3. Copy the rows found in multiple worksheets that contain...