Automatic clearing of a chart/table.

An easy way to do this is to select all the cells you want to clear at the end of the week and make these a named range. (I use "ToDelete"). Then you can create a macro to select that named range and delete the contents. An example of the actual VB code would be:

Sub DeleteAuxOrder()
'
' DeleteAuxOrder Macro
' Clear the AUX order form
'
' Keyboard Shortcut: Ctrl+Shift+D
'
    Application.Goto Reference:="ToDelete"
    Selection.ClearContents
    Range("A2").Select
End Sub