merge excel workbooks

[Theresa]

Is it possible to merge several excel workbooks....

 

[JulieD]

Hi Theresa

what exactly do you mean by merge ... do you want to consolidate (ie add /
count / average whatever) the figures in multiple workbooks or do you have
say 2 similar workbooks that have been edited by different people and you
want to merge them to compare the differences (like you can do in Word)?

Cheers
JulieD

 

[Theresa]

I have four seperate workbooks. Each of the books has information that i
would like to have on one spread sheet and have all the info together in just
one book...I was hoping that I could avoid the "cut and paste" and also
delete the duplicate, ie name, address, etc. info...the only thing in commom
with each of the books is a number assigned to each specific customer...so,
is it possible to do this?

 

[JulieD]

Hi Theresa

with only 4 workbooks (unless they have lots of sheets) i don't think the
alternative to cutting & pasting, namely, VBA code will save you any time -
however, with regards to avoiding duplications you might like to check out
http://www.cpearson.com/excel/duplicat.htm

Cheers
JulieD