How do I automatically pull data from one Excel sheet to another?

How do you reference a cell value in another sheet in VBA?

I have a sheet which holds a list of a few thousand names.

I have another sheet that will do a search to find a name in the list. I'd like to return the value of the cell (in the list sheet) the name matched from.

The sheet name is Table List with column headers of Last Name, First Name, Middle Name, etc. The other sheet name is Sheet1 and it has 2 columns labeled Last Name and First Name. I need a formula to look for the value "Last Name" in Column B and return the matching value from Column A in the same row as the cell containing the formula.

In the example below I'd like for it to return Last Name. It could also be First Name or Middle Name as long as it returns the value of the cell in the same row.

How do I automatically pull data from one Excel sheet to another?

I have 2 Excel files, one is the source file and one is the destination file.

The source file contains some data that I want to import into the destination file. How do I get that data from the source file to the destination file? I know how to import data from one file to another using VBA, but how can I automatically pull data from one file to another. I need a solution that does not require me to manually input the data. Thanks in advance.

You could try ImportXML. Sub Importdata(). Dim source As String. Dim xmlDoc As MSXML2.DOMDocument60 Dim parent As Object. Dim parent1 As Object. Dim parent2 As Object. source = "source.xlsx" Set xmlDoc = New MSXML2.DOMDocument60 xmlDoc.async = False xmlDoc.Load (source) Set parent = xmlDoc.