43,753 views
Step by step guide to query another Excel spreadsheet without having to open it, through connections between Excel files. How to connect one spreadsheet to another in Excel using data query. And display the data in a table or create pivot tables and reports based on the data in the other Excel spreadsheet. The procedure makes it easier to share information from Excel spreadsheets by connecting to the data in the other file with the Excel connections function. Video link Class to create an Excel VBA form: • Save DATA to ANOTHER Excel spreadsheet... Next Class: Filter Data from Another Closed Spreadsheet: • Advanced Excel Filter - SEARCH DATA... ✅SGP Website: Sale of a Collection of Ready-Made Excel VBA Spreadsheets: https://www.planilhascanalsgp.com.br/ =================