I am the record keeper for The Riders Club. The workbook is titled The Riders
Dues. The two sheets I am working with are Balances & Statement. I want to
pull data from the Balances and print Statements.

Per Balances - Name A5, Date Joined B5, SS# C5, Yrs in Club F5, Bal due M5,
Past due N5.

I would like to have this repeat printing up to the end of the list.

Thank you

JulianB

"Bernie Deitrick" wrote:

Julian,

Visit

http://www.mvps.org/dmcritchie/excel/getstarted.htm

for how to work with macro code.

As for the specific code, post back with:

Your sheet names.
The cells that have the SS #'s
The cells that have the other data.
Which sheet you want printed.
Which cells on that sheet should have what information.

And then I will modify my code to match your specifics.

HTH,
Bernie
MS Excel MVP


"JulianB" wrote in message
...
Bernie,

All this is new to me. Can you give me step by step for Dummys"

"Bernie Deitrick" wrote:

Julian,

Let's say that you have SS in column A, something else in B, C, and D,
and
you want that information to to into Sheet2 cells B2B5.

Something along the lines of

Sub PrintReports()
Dim myCell As Range

For Each myCell In Worksheets("Sheet1").Range("A2:A123")
With Worksheets("Sheet2")
.Range("B2").Value = myCell.Value
.Range("B3").Value = myCell(1,2).Value
.Range("B4").Value = myCell(1,3).Value
.Range("B5").Value = myCell(1,4).Value
.Printout
End With
Next myCell

End Sub

HTH,
Bernie
MS Excel MVP

"JulianB" wrote in message
...
I have a work sheet with a list of members. This list contains the
name,
SS#,
and the amount of dues owed to date. I have a form on another work
sheet,
in
the same workbook. How do I create a macro taking the info on the
list,
puting it on the form and printing the Dues Statement. I then have to
repeat
this for eash member until the end of the list.