Hi all
I have a worksheet with hundreds of tabs of data, one per person, named as the person's name.
The person's name is in Cell A3 on each sheet.
I need a macro to look on each sheet for a specific value and, if found, to pull the person's name, that value and a number of cells to the right...