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 Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,218,620
Messages
6,143,527
Members
450,493
Latest member
Woejeber

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
Back
Top