Hi thanks for the rplies,
I have decided to start from scratch with this workbook so the tips
will come in very usefull.
Howvever I have another question. I am using the below code to sort the
data from one sheet (by Team Name) then copy onto another. I have used
the "CurrentRegion" as the workload will vary from week to week.
However after running the macro it always errors with "the paste method
of worksheet class faild".I have tried using paste values only but
still no luck.

Sheets("DAY 1 CUTTING LIST").Select
ActiveWindow.SmallScroll ToRight:=4
Selection.AutoFilter Field:=10, Criteria1:="TEAM B"
ActiveWindow.ScrollColumn = 1
Range("A10").CurrentRegion.Copy Sheets("DAY 1 TEAM
B").Range("A10")
Range("A10").Select
ActiveSheet.Paste
Range("A10").Select
Sheets("DAY 1 CUTTING LIST").Select

Many Thanks

J



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/