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