Cycling through filtered rows

[mckillenj]

Hi Everyone-
I have a workbook with two sheets. Sheet1 is named Log_Proceeds and Sheet2 is named Other Income. Sheet one consists of rows of Stock data with column fields such as Broker, Shares, amount, date, and so on. The column headings appear on Row 6 with the data beginning on Row 7. This list is manually autofiltered. Row 3 of this sheet is reserved for copying and pasting the filtered rows one at a time because as each row is copied and pasted to Row 3, I then print out one copy of Sheet2 which pulls the data from Row 3 on Sheet1 using formulas. I then cycle to the next row in the filtered list until all rows and copied, pasted, and Sheet2 is printed. My question is can this process be automated from the time after I manually autofilter this list? I am running Excel 2003 on Windows XP Pro. A copy of my meager code beginnings follows:

Sub OtherIncomePrint()
Application.ScreenUpdating = False
With Worksheets("Log_Proceeds")
ActiveCell.EntireRow.Copy Worksheets("Log_Proceeds").Rows("3:3")
Application.CutCopyMode = False
Sheets("Other Income").PrintOut
End With
Application.ScreenUpdating = True
End Sub

Thanks for any help you can give and also thanks for help you have given me in the past!