Merge two sheets into third sheet
 

Hi There,

I have two books, both contain many sheets, and I would like to merge
some of those sheets (say sheets A, B and C in first book, and sheets x,
y, z in second book) into a a new (stand alone)book (say called "final"
which will then have sheets a,b,c,x,y,z)

Catches a
1) the sheets probably have more than 255 characters in certain cells
2) I dont want any formulaes to be copied across
3) I want the format (ie column widths, row heights, and cell
formatting) to be exactly the same in the new book as it was in the old
book.
4) The merged sheets has a couple of stand alone sheets in it. (ie not
found in firstbook or second book)

APPROACH
I was hoping to open the blank template (FINAL) with the standard sheets
in. Then run a macro which would open the two books and copy the sheets
across into the new book.

I can get Excel to open the sheets, but not to copy other sheets
across...

Any ideas... MOST MOST welcome...

(It may be easier to copy all sheets across and then delete from FINAL,
then individully selecting before copying across....?)

Kind Regards

Darin

*** Sent via Developersdex http://www.developersdex.com ***