How do I copy a “find all” result to another spreadsheet?

Answer 1

To my knowledge, the "Find" result is dynamic and not "copyable" unless you take a screen shot of the results, which may not prove useful. Another solution is to apply filters to your data, easily achieved by turning your data into a Table. Excel's Table feature contains expansive search criteria within each filter, which will enable you to zero in on your desired results. Your results will show in consecutive rows, which could then be easily copied.