Merging data from different work sheets

Dhawk

New Member
Joined
Aug 28, 2002
Messages
13
I am a beginner with Excel, so please excuse me if I use the wrong terminology or pose my question improperly.

I have two spread sheets. The first one is a master record of Technician stats, with their certifications and cert dates.

The second spread sheet is an update with the Technicians names and new updates on their cert dates.

What I would like to do is merge, or import the new cert dates on the idividual Techs from the second sheet to the first Master sheet and hopefully overwrite any date changes.

If you need more info this to help me, let me know. Thanks
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Corticus

Well-known Member
Joined
Apr 30, 2002
Messages
1,579
Welcome!

Make sure you have the same feild names:

Open the two files you want to combine.

Select the one that will be "receiving" data.

Select data...consolidate

Use the reference box to select the range from the sheet you will be receiving data from, you can just select that file while the consolidate dialog box is still open and highlight that range you're interested in.

Hit Ok

Hope that does it!
Corticus
 

Dhawk

New Member
Joined
Aug 28, 2002
Messages
13
Corticus

Thanks for the welcome and the reply.

I still a couple of questions on how to do this.

What function should I use?

Will this method be able to match the dates up to the appropriate name?

Thanks again for the help.
 

Corticus

Well-known Member
Joined
Apr 30, 2002
Messages
1,579
Getting external data in this manner is going to append your recordset 1,(the file from which you initiate the "merge") with the data from recordset 2, which is the file to which you are refering.

Excel is just going to add the records from one feild in recordset1 to the feilds of the same name in recordset 2.

If this isn't what you're looking to do, let me know.

It sounds like maybe you need data to be "matched" to appropriate records, if this is the case, my method won't work.

With some more info perhaps I can provide a more specific method.

BTW, no formulas.

HTH,
Corticus
 

Forum statistics

Threads
1,148,530
Messages
5,747,238
Members
424,070
Latest member
smanni3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top