Hi I was wondering if someone could help.

What id like to do is run through a list on sheet (Load Sheet) and check column A

if the value is 631 cut and paste the whole row and move to sheet(631) and put it in the last row

on the Load Sheet there is normally around 3000 rows and there is 6 possible values 629.631.646,647,650,651 and six possible sheets named the same, so what id like to achieve is every record is moved to the relevant sheet and added to the bottom of the list on that sheet. Any help would be greatly appreciated.

Regards Dean