Can you merge two spreadsheets?

[LukeJ]

I have 13 spreadsheets from all the local councils in my area and i need to merge all the information into one big database. I can't seem to find out how to do this. Plus some of the headings are slightly different or under different letters, is there anyway around this?

 

[just_jon]

Welcome to the Board, Luke -- well, if either the sheets were in the same structure or if the column headings were identical from sheet to sheet, it would be easier. Any chance of that happening?

 

[plettieri]

Hi:

Welcome to the board!!

It might help to show some examples of your data since you describe "some of the headings are slightly different or...

You can use the Colo utility to do this which is located at the bottom of this message box.

plettieri

 

[Smitty]

Welcome to the Board Luke!

It might make things a bit easier if you looked at the bottom of the page for the link to Colo's HTML maker, so that you can post some representative shots of what you're working with.

Let everyone take it from there!

Smitty

 

[LukeJ]

Hi,
I found a program to merge the spreadsheets and it seems to have worked ok, but now i have a spreadsheet with 6500 entries and a lot of duplicates. I would like to be able to highlight the duplicates so that i can look at them before i delete one. This is because say if there was a company in Ashford but it appears in the Ashford and Canterbury database then i need to delete the Canterbury entry as it is not in their borough

 

[plettieri]

Hi:


Might try this earlier post

http://www.mrexcel.com/board2/viewtopic.php?t=77888&highlight=highlight+duplicates

then you can delete the dups by...

After hightlighting your data of interest..

DATA| FILTER |ADVANCED FILTER, then check unique records box...

hope this helps

plettieri

 

[LukeJ]

Ok ok, the merge didnt work, i've got 13 files each with about 2000 entries on the first spreadsheet in each workbook. Now i tried to use ASAP utilities to combine them all but i only got 6500 entries once they were combined. I have managed to get them all under the same headings so no problem there. I just need to take the first sheet from 13 workbooks and comebine them all into one big spreadsheet.

 

[just_jon]

When you say combine, do you mean --

A] Stack the data from sheet2 below sheet1, sheet3 below sheet2, etc or
B] Add cell A1 from each sheet 1-13 into cell A1 on the summary sheet.

 

[LukeJ]

i mean just take all the data from sheet 1 in every workbook and stick all of it onto one big sheet. so say i have 13 workbooks with 2000 entries then once they were together i would have one sheet with 26,000 entries

 

[plettieri]

Hi:

If it is just a one time deal....cut and paste and be done with it....then perform the sorting / filtering aspect of the task....

plettieri