Hi!

I'd be grateful if someone could help me.

I have a number of worksheets where I need to merge/consolidate 2 or 3 together. They have been downloaded from a Financial Analysis Database where the company name is listed in the first column and the analysis is provided on the rows. The problem is that the database would not allow me to download all the information I needed, hence I had to save them in two or three files where the name of the company is the index.

eg worksheet no 1 had company A years 1-5 whereas worksheet no 2 had company A years 6-10 and I need them to be merged into one worksheet to show company A years 1-10.

It would take an eternity to do it manually and I wonder if there is a quick way that I can merge/consolidate them. Most of the searches I've found are merely putting them in the same place i.e. not sorting them (it's not as easy as to merely copy and sort).

If anyone has any ideas or knows of software that will do this it would be very much appreciated.

Many thanks.

Karl