Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - Merging data from 2 separate spreadsheets

Excel - Merging data from 2 separate spreadsheets

ResolvedVersion 2007

Thu 1 Apr 2010, 15:00 Delegate Natalie said...

Natalie has attended:
Excel Advanced course

Excel - Merging data from 2 separate spreadsheets

If you have data in separate spreadsheets that you want to merge, i.e. 1 row of data related to each individual but with different data and different numbers of individuals on each spreadsheet, what is the easiest way to do this?

Wed 7 Apr 2010, 16:45 Trainer Simon said...

RE: Excel - Merging data from 2 separate spreadsheets

Hi Natalie,

Thank you for your question and sorry for the delay in responding.

You will not be able to use the Compare and Merge option if the workbooks are not shared.

If your two workbooks are unrelated such that they are not shared workbooks, and one isn't a 'child' of the other, then you'll have to copy the data from one book to the other either manually or through the use of a macro/vba.

I hope this answers your question.

Regards

Simon

Wed 14 Apr 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Select only cell that contain text to lock format

For selecting cells that only contain Text in Excel

By selecting cells that only contain text, you can delete, fill or protect cells of this type.

Use short cut to Go to box (F5) or Edit, Go to
In the dialog box, click special button & select Constants and only check text or any other desired type.

Click OK.

And text cells will all be highlighted for you to apply format. Please note only works on one sheet at a time.

View all Excel hints and tips

Excel - Merging data from 2 separate spreadsheets

Excel - Merging data from 2 separate spreadsheets

RE: Excel - Merging data from 2 separate spreadsheets

Excel articles

Excel tip:

Select only cell that contain text to lock format