Clarification:
Copy E1:F1 down to F2000 (the last row)

should have read as:
Copy E1:F1 down to F500 (copy down by 500 rows)

since you are checking for numbers: 1 - 500 within the source data
The extent of your source data is immaterial
The "copy down by x rows" step is where x = the range of numbers checked
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---