So I have a problem and I can't seem to find a similar question asked before.
I have an excel workbook with 10 sheets.
Each sheet is regarding a different issue.
Details of that person are entered as a new row on the sheet that applies (as and when there is an issue). Name in A, Number in B, Day in C, Specific Details in D etc.
I need to be able to search the entire workbook (similar to Ctrl+F) but then have all the results copied, or marked to copy. As it stands at the moment the "results" from the search can be between 0 and 40.
Is there anything I can do (be it a macro or existing Excel function) to achieve this?