Hi Skiman,

Data entry may be slowed on large datasets (i.e. thousands of records) as for every change it checks if the value exists in Sheet1 and if does, deletes the row where the value resides. If this isn't the case, I wouldn't worry.

The error below may be due to the code trying to assign a non numeric value to the lngMyValue variable.

The code could be adapted so that it could run on an existing data set that has been copied and pasted into Sheet2, but I'd say you'd have to start a new thread as it's quite different to your original one.

HTH

Robert