This is a bad idea!

What happens when the user makes a mistake?

There's no way to undo it.

--
Biff
Microsoft Excel MVP


"Colin Fisher" <Colin wrote in message
...
I want to allow the user to type an Integer value into a worksheet cell.
The
cell value is added to the previous cell entries from that same cell and
displayed in a linked cell on a separate worksheet.

If possible, all values for previous weeks entries on the worksheet can be
retrieved and displayed without the need to store each spreadsheet as a
separate file.

Any help on this would be grealty appreciated