Have several spreadsheets to be filled out by salesmen - Would like to roll
each sheet up into a master sheet leaving no blank rows. Some sheets may
have 2 rows - some may have 20 rows. Have about 20 sheets and 1 master sheet.

Try
http://www.rondebruin.nl/copy2.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Combining spreadsheets in Excel" <Combining spreadsheets in wrote in message
...
Have several spreadsheets to be filled out by salesmen - Would like to roll
each sheet up into a master sheet leaving no blank rows. Some sheets may
have 2 rows - some may have 20 rows. Have about 20 sheets and 1 master sheet.

Can I modify this code to update the master worksheet each time it is opened
instead of adding the master?

"Combining spreadsheets in Excel" wrote:

Have several spreadsheets to be filled out by salesmen - Would like to roll
each sheet up into a master sheet leaving no blank rows. Some sheets may
have 2 rows - some may have 20 rows. Have about 20 sheets and 1 master sheet.

Delete the sheet first in the code and then run the rest of the code


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Combining spreadsheets in Excel" t.com wrote in message
...
Can I modify this code to update the master worksheet each time it is opened
instead of adding the master?

"Combining spreadsheets in Excel" wrote:

Have several spreadsheets to be filled out by salesmen - Would like to roll
each sheet up into a master sheet leaving no blank rows. Some sheets may
have 2 rows - some may have 20 rows. Have about 20 sheets and 1 master sheet.