Hi everyone

I'm hoping the forum will be able to help with this problem for me.

The aim is to try and automate repetitive data entry; check for duplicated entries and try to prevent operator entry errors.

A sample of Data input is shown below as follows:

entrydate cli acc val
04/03/2006 1008 L566 30.00
04/03/2006 3298 L100 10.00
04/03/2006 3605 L057 15.00
04/03/2006 3605 L406 15.00
04/03/2006 4357 L597 35.00
11/03/2006 1008 L566 30.00
11/03/2006 3605 L057 15.00
11/03/2006 3605 L406 15.00
11/03/2006 3605 L789 15.00
11/03/2006 8797 L100 1.00
11/03/2006 8797 L101 5.00
11/03/2006 8797 L102 50.00
11/03/2006 8797 L103 5.00
18/03/2006 1008 L566 15.00
18/03/2006 3605 L406 15.00
18/03/2006 4357 L597 35.00
18/03/2006 3298 L100 20.00
18/03/2006 8797 L101 5.00
18/03/2006 8797 L102 50.00

This data is entered weekly at the moment to avoid duplication but I would prefer to enter the data as and when it becomes available but this opens the door to duplicate entries.

The date will always reflect the end of the week in which it is entered, so this would be constant for every entry for that week. However, since the data may not be entered until Sunday; using the system date could produce incorrect results.

Clients may have more than one a/c but the weekly amount may change but I estimate that about 60% of the data entered each week is the same as the previous week. The data is then manipulated by a Pivot Table to produce results/figures in other worksheets.

To reduce data input there is no need to enter a/c's which have a Zero amount for that week; provided the a/c is already present in a previous week.

Sorry if this seems a long post but I thought it best to try and outline the current situation as best possible.

Thanks in advance again!