Merge two sheets into third sheet

D

Darin Kramer

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 are:
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 ***
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top