Can overwritten data be stored?

[TheBarran]

I'm making a spreadsheet for my hours worked and wage earnt. Is it possible to have a single entry table which can be overwritten weekly but all the information from previous weeks stored on a different sheet?

[Blake 7]

You could always create a database


1. Click on down arrow at the end of the Quick Access Toolbar to open the drop down menu.

2. Choose More Commands from the list to open the Customize the Quick Access Toolbar dialog box.

3. Click on down arrow at the end of the Choose commands from line to open the drop down menu.

4. Choose All Commands from the list to see all the commands available in Excel 2007 in the left hand pane.

5. Scroll through this alphabetical list to find the Form command.

6. Click on Add button between the command panes to add the Form command to the Quick Access Toolbar.

7. Click OK.

8. The Form button should now be added to the Quick Access Toolbar.

[royUK]

The Contacts Form example demonstartes how to save data from one sheet used as a form to a master sheet (database)