Question: how to extract data from one spreadsheet to another in excel?
Answer: Go to Sheet2 (see the steps on the video above) Select a cell in an unused part of the sheet (cell C4 in this example). On the Excel Ribbon's Data tab, click Advanced. Choose Copy to another location. Click in the List Range box. Select Sheet1, and select the database.