How to get data like CTRL+F, but query another spreadsheet
I have a large spreadsheet with many tabs that I want to keep in a secure location. I want to be able to query it, essentiallly exactly the way CTRL+F does, when set to "entire workbook", to be able to find cells that contain the search key, with a report out that shows at least the tab name. So, is there a way to CTRL+F but to apply it to a completely different workbook?
Recent comments
6 years 7 weeks ago
6 years 45 weeks ago
7 years 5 weeks ago
7 years 8 weeks ago
7 years 9 weeks ago
7 years 14 weeks ago
7 years 22 weeks ago
7 years 23 weeks ago
7 years 23 weeks ago
7 years 23 weeks ago