merging and mailing multiple worksheets
 

i have 162 projects that require a budget. currently all the projects have
budget template on a worksheet with a tab that names the project. let's call
this workbook with 162 tabs Master. i want to email these templates to the
appropriate office. Some offices are responsible for more than 1 project so
they'd get more than one worksheet. after the office has filled out the
budget, i want to be able to populate Master with the new worksheets. i'm
not sure how to approach this problem. should i just send out a template to
the offices and create the Master when the filled out worksheets come to me?
this seems the least complicated. how do you merge many worksheets into the
Master workbook with a tab for each project?

thanks in advance for any help that you can give me.--
BDW

merging and mailing multiple worksheets
 

Send the one sheet template workbook and merge the one sheet workbooks to one
When you get them back

Start here
http://www.rondebruin.nl/mail/folder2/saveatt.htm

Then use the code here
http://www.rondebruin.nl/fso.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"April" wrote in message ...
i have 162 projects that require a budget. currently all the projects have
budget template on a worksheet with a tab that names the project. let's call
this workbook with 162 tabs Master. i want to email these templates to the
appropriate office. Some offices are responsible for more than 1 project so
they'd get more than one worksheet. after the office has filled out the
budget, i want to be able to populate Master with the new worksheets. i'm
not sure how to approach this problem. should i just send out a template to
the offices and create the Master when the filled out worksheets come to me?
this seems the least complicated. how do you merge many worksheets into the
Master workbook with a tab for each project?

thanks in advance for any help that you can give me.--
BDW