Copy Work Sheet


Another common requirement in Excelerator is the need to copy or make a duplicate of a work sheet within Excel. 

Due to the fact that Excelerator use ranges, to map between Excel and Sage, the normal Ms Excel copy a work sheet procedure does not work for Excelerator.


Excelerator copy work sheet Tool

Select the Work Sheet you wish to Copy - go to the ribbon of the associated module and choose Tools.  Then select Copy Work Sheet from the menu. 

 CEModule Tools - Excelerator Help

The following dialogue box appears where you can type a new name for the copied work sheet.Renaming the worksheet

Click OK and the current worksheet, along with all the Excelerator ranges, will be copied to the new sheet.

This could be particularly useful when copying a monthly worksheet from one month to the next.