combining workbooks into a single workbook

[psgreen]

hi i am a REAL novice at excel. i have kept my freelance expense report
on excel, each one in a seperate workbook using a template which
created. now, i need to combine all my 2003 workbooks into one maste
file. is there any EASY way to do this?

thanks very much..

 

[mudraker]

To get a macro to do this for you we would need some details


How many books do you need to merge?

How many sheets in each book?

IS Each book to be placed on one sheet in the master workbook or i
each sheet to be copied as a new sheet into the master book?

Are each book in the same directory?

Is there a naming convention you have used for each Workbook
worksheet?

Are teir other Excel files in the Director which will not need to b
copied to the master book

 

[psgreen]

To get a macro to do this for you we would need some details

* thanks here goes:

How many books do you need to merge?

* about 50 or 100 per year for the past 3 years

How many sheets in each book?

* only 1 or two shets per book

IS Each book to be placed on one sheet in the master workbook or i
each sheet to be copied as a new sheet into the master book?


* it would be better if they were each seperate sheets in a singl
workbook

Are each book in the same directory?

* yes.

Is there a naming convention you have used for each Workbook
worksheet?

* yes - each has a number 01 001 for first january bill 12 783 for th
783d bill in december

Are teir other Excel files in the Director which will not need to b
copied to the master book.

*no. thanks!!!!

psgreen hi i am a REAL novice at excel. i have kept my freelanc
expense reports on excel, each one in a seperate workbook using
template which i created. now, i need to combine all my 2003 workbook
into one master file. is there any EASY way to do this?

thanks very much..