combine speadsheets leaving no blank rows on master page

  • Thread starter Combining spreadsheets in Excel
  • Start date
C

Combining spreadsheets in Excel

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.
 
C

Combining spreadsheets in Excel

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