Sub bigConversion() ' ' bigConversion Macro ' Macro recorded 2/28/2007 by STEVENSB ' ' Range("A1:C500").Select Selection.Copy Sheets("Scrap").Select ActiveSheet.Paste Sheets("Container List").Select Range("A1:CZ5000").Select Application.CutCopyMode = False Selection.Copy Sheets("Scrap").Select ActiveWindow.LargeScroll Down:=1 Range("A49").Select ActiveWindow.LargeScroll Down:=1 Range("A97").Select ActiveWindow.LargeScroll Down:=1 Range("A145").Select ActiveWindow.LargeScroll Down:=1 Range("A193").Select ActiveWindow.LargeScroll Down:=-1 Range("A145").Select ActiveWindow.LargeScroll Down:=1 Range("A193").Select ActiveWindow.LargeScroll Down:=1 Range("A241").Select ActiveWindow.LargeScroll Down:=1 Range("A289").Select ActiveWindow.LargeScroll Down:=1 Range("A337").Select ActiveWindow.LargeScroll Down:=1 Range("A385").Select ActiveWindow.LargeScroll Down:=1 Range("A433").Select ActiveWindow.LargeScroll Down:=1 Range("A481").Select ActiveWindow.LargeScroll Down:=1 Range("A529").Select ActiveWindow.LargeScroll Down:=-1 Range("A501").Select ActiveSheet.Paste Sheets("Main").Select Range("E6").Select Application.CutCopyMode = False Selection.Copy Sheets("Scrap").Select ActiveWindow.ScrollRow = 5453 Range("A5502").Select ActiveSheet.Paste Range("A1:CZ5502").Select Range("A5502").Activate Application.CutCopyMode = False Selection.Copy Range("A1").Select End Sub