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?

 

[LukeJ]

welll for starters its not a one time thing. Also i tried that bt i have to scroll down miles before it will let me paste.

 

[plettieri]

Hi:
Not sure why you needed to scroll...but...


Well here is some code and explainations about what I think you might be looking for...

see and read...maybe you can adapt this

http://www.mrexcel.com/board2/viewtopic.php?t=57836&postdays=0&postorder=asc&start=0

Be sure to read to the end of the post as there were some modifications early on

hope this helps

plettieri

 

[Mark F]

These links any use?

http://www.mrexcel.com/board2/viewtopic.php?t=71069&highlight=merge+worksheets [url]http://www.mrexcel.com/board2/viewtopic.php?t=73200

Mark

 

[LukeJ]

Hi agian,
yea those things worked but like the ASAP utility they on made a document with around 6000 entries when the finished thing should be around 20,000.
Any ideas??