Print all data from list on seperate form
 

I'm pretty new with Excel macros & have no experience
with VB. Is there a way that I can dump some of the data
(columns) from one worksheet into a form and print that,
then have it automatically move to the next record and
print that. Right now, I'm typing in the customer's name
and using VLOOKUP functions to dump all of the data for
one record. I print that, then have to type the
customer's name to print the next record. There are
about 200 customers, so this takes quite a while.

Thanks,
Kevin

Print all data from list on seperate form
 

Try this

Cell a1 in the sheet "form" is the cell with the customer's name
sheet "data" have the lookup information with in column A the customer's names

Sub test()
Dim cell As Range
For Each cell In Sheets("data").Range("a1:a10")
Sheets("form").Range("A1").Value = cell.Value
Sheets("form").PrintOut
Next
End Sub

Change Range("a1:a10")
to Range("a1:a200") if it is working for you

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Kevin" wrote in message ...
I'm pretty new with Excel macros & have no experience
with VB. Is there a way that I can dump some of the data
(columns) from one worksheet into a form and print that,
then have it automatically move to the next record and
print that. Right now, I'm typing in the customer's name
and using VLOOKUP functions to dump all of the data for
one record. I print that, then have to type the
customer's name to print the next record. There are
about 200 customers, so this takes quite a while.

Thanks,
Kevin

Print all data from list on seperate form
 

Ron,
That worked great, thanks for the help.

Kevin

-----Original Message-----
Try this

Cell a1 in the sheet "form" is the cell with the
customer's name
sheet "data" have the lookup information with in column A
the customer's names

Sub test()
Dim cell As Range
For Each cell In Sheets("data").Range("a1:a10")
Sheets("form").Range("A1").Value = cell.Value
Sheets("form").PrintOut
Next
End Sub

Change Range("a1:a10")
to Range("a1:a200") if it is working for you

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Kevin" wrote in message
...
I'm pretty new with Excel macros & have no experience
with VB. Is there a way that I can dump some of the data
(columns) from one worksheet into a form and print that,
then have it automatically move to the next record and
print that. Right now, I'm typing in the customer's
name
and using VLOOKUP functions to dump all of the data for
one record. I print that, then have to type the
customer's name to print the next record. There are
about 200 customers, so this takes quite a while.

Thanks,
Kevin


.