Cycling through filtered rows

mckillenj

New Member
Joined
Nov 21, 2004
Messages
19
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!
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Forum statistics

Threads
1,136,878
Messages
5,678,306
Members
419,754
Latest member
LordEddard

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top