Morning all,
I have done a Macro in Excel 2003 to copy and paste infomation from one sheet to my form I have setup in another sheet.
Can someone add to my macro so it continues copying the the data down the rows until it reaches a blank row, please 
Many thanks.
'
' Macro4444 Macro
' Macro recorded 12/05/2009
'
' Keyboard Shortcut: Ctrl+d
'
Sheets("Sheet 3").Select
Range("F2").Select
Selection.Copy
Sheets("Side One").Select
ActiveSheet.Paste
Range("G42").Select
Sheets("Sheet 3").Select
Range("E2").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Side One").Select
ActiveSheet.Paste
Range("D48").Select
Sheets("Sheet 3").Select
Range("A2:D2").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Side One").Select
ActiveSheet.Paste
Range("I48").Select
Sheets("Sheet 3").Select
Range("G2").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Side One").Select
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Sheet 3").Select
Range("A3").Select
End Sub
Bookmarks