How To Pull Data From Another Sheet In Excel 2010

How to import data from another worksheet?

When you operate an Excel file, you may want to import some data from another worksheet into your electric current worksheet. Today, I volition talk about some interesting tricks for you lot to deal with this problem.

Import data from some other worksheet with Connections part

Import data from another worksheet with VBA code

Import data from some other worksheet with Kutools for Excel

Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Piece of work Much Easier...

Kutools for Excel Solves Well-nigh of Your Issues, and Increases Your Productivity past eighty%

Reuse Anything: Add together the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
More than than 20 text features: Excerpt Number from Text Cord; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
Merge Tools: Multiple Workbooks and Sheets into Ane; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Indistinguishable Rows and Sum.
Split Tools: Dissever Information into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; Ane Column to Multiple Columns.
Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Ship Personalized Emails to Multiple Recipients in Bulk.
Super Filter: Create avant-garde filter schemes and use to any sheets; Sort past week, day, frequency and more; Filter past bold, formulas, annotate...
More than than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.

Import data from some other worksheet with Connections function

Hot

If you are familiar with the Connections feature in Excel, you can import another worksheet data into electric current workbook, and your imported data volition be updated with the original data automatically.

i. Become to click Data > Connections, see screenshot:

doc-import-data-to-worksheet-1

2. In the Workbook Connections dialog, click Add together button, and in the popped out Existing Connections dialog, click Scan for More than push, meet screenshots:

3. And then choose the workbook that you want to export its data to current worksheet.

doc-import-data-to-worksheet-1

four. After choosing the workbook, delight click Open up push button, and select i worksheet that you want to utilise. Come across screenshot:

doc-import-data-to-worksheet-1

5. Then click OK, it will return to the Workbook Connections dialog box, and your selected workbook is added to the list box, please close this dialog.

6. Then go on clicking Data > Existing Connections, see screenshot:

doc-import-data-to-worksheet-1

seven. In the Existing Connections dialog box, click the workbook that you are added but now, and click Open up button. See screenshot:

doc-import-data-to-worksheet-1

eight. And in the popped out Import Data dialog, cull one choice you like from the Select how you want to view this information in your workbook, and and so cull one the existing worksheet range or a new worksheet to put the data.

doc-import-data-to-worksheet-1

9. And then click OK, the data from another worksheet has been imported into your specified worksheet.

doc-import-data-to-worksheet-1

Notes:

one. Using this method, you tin import the data with the type of table, PivotTable Report or PivotChart and PivotTable Report.

2. Your workbook has been connected to that external data, if you desire to go the latest data in your own workbook. Go to Data > Refresh All to get the updated data.

doc-import-data-to-worksheet-1

Import information from another worksheet with VBA code

In that location are then many steps of above method, may exist y'all volition feel tired, here, the following VBA code also can assistance y'all to import information from some other worksheet.

i. Hold downwards the ALT + F11 keys, and it opens the Microsoft Visual Bones for Applications window.

2. Click Insert > Module, and paste the following code in the Module Window.

VBA lawmaking: Import data from some other worksheet

          Sub ImportDatafromotherworksheet()     Dim wkbCrntWorkBook Equally Workbook     Dim wkbSourceBook Equally Workbook     Dim rngSourceRange As Range     Dim rngDestination As Range     Set wkbCrntWorkBook = ActiveWorkbook     With Awarding.FileDialog(msoFileDialogOpen)         .Filters.Clear         .Filters.Add together "Excel 2007-13", "*.xlsx; *.xlsm; *.xlsa"         .AllowMultiSelect = False         .Show         If .SelectedItems.Count > 0 And then             Workbooks.Open .SelectedItems(1)             Set wkbSourceBook = ActiveWorkbook             Set rngSourceRange = Application.InputBox(prompt:="Select source range", Title:="Source Range", Default:="A1", Type:=8)             wkbCrntWorkBook.Activate             Ready rngDestination = Awarding.InputBox(prompt:="Select destination prison cell", Title:="Select Destination", Default:="A1", Type:=8)             rngSourceRange.Re-create rngDestination             rngDestination.CurrentRegion.EntireColumn.AutoFit             wkbSourceBook.Shut False         Finish If     End With Terminate Sub

3. And then press F5 key to run this lawmaking, and choose the workbook that you desire to insert its data into current workbook, see screenshot:

doc-import-data-to-worksheet-1

4. After selecting the workbook, then click Open button, and select a worksheet or a range of your specified workbook which data you need to export. Run into screenshot:

doc-import-data-to-worksheet-1

5. Then click OK, and select one cell to put your imported data in your current worksheet, see screenshot:

doc-import-data-to-worksheet-1

6. Go on clicking OK, and your selected data has been imported into your worksheet.

Notation: With this method, the imported information volition non update with the original data.

Import data from another worksheet with Kutools for Excel

Kutools for Excel too provides Insert File at Cursor feature for you to solve this problem.

Kutools for Excel includes more 300 handy Excel tools. Gratis to endeavour with no limitation in 30 days. Go information technology Now

ane. Open your workbook that you lot desire to insert another worksheet information.

2. Click Enterprise > Import / Export > Insert File at Cursor, run into screenshot:

doc-import-data-to-worksheet-1

3. And in the Insert File at Cursor dialog box, select a cell which you want to put the information begin in, and then click Browse button to select one workbook that you want to insert.

doc-import-data-to-worksheet-1

4. Then click OK, and cull i worksheet if your workbook contains multiple worksheets from the Select a Worksheet dialog, come across screenshot:

doc-import-data-to-worksheet-1

v. And then click OK, your selected worksheet has been imported into your specific worksheet.

Note: With this method, the imported data will non update with the original data.

To know more almost this Insert File at Cursor feature.

Related article:

How to import a text file or worksheet in Excel?

The Best Office Productivity Tools

Kutools for Excel Solves Nearly of Your Bug, and Increases Your Productivity by 80%

Reuse: Quickly insert complex formulas, charts and anything that yous take used before; Encrypt Cells with password; Create Mailing Listing and send emails...
Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (hands read and edit large numbers of cells); Paste to Filtered Range...
Merge Cells/Rows/Columns without losing Information; Divide Cells Content; Combine Indistinguishable Rows/Columns... Forestall Indistinguishable Cells; Compare Ranges...
Select Duplicate or Unique Rows; Select Bare Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
Exact Copy Multiple Cells without irresolute formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more than...
Extract Text, Add together Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Catechumen Betwixt Cells Content and Comments...
Super Filter (save and apply filter schemes to other sheets); Avant-garde Sort by calendar month/week/day, frequency and more; Special Filter by assuming, italic...
Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features thirty-solar day free trial. threescore-day money back guarantee.

kte tab 201905

Office Tab Brings Tabbed interface to Office, and Brand Your Work Much Easier

Enable tabbed editing and reading in Word, Excel, PowerPoint , Publisher, Access, Visio and Projection.
Open and create multiple documents in new tabs of the same window, rather than in new windows.
Increases your productivity by 50%, and reduces hundreds of mouse clicks for y'all every day!

officetab bottom