Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop-down list on simple excel 2003 form using "form" from data me | Excel Discussion (Misc queries) | |||
How to print a bunch of files form the list (excel)? | Excel Discussion (Misc queries) | |||
Print data only from form | Excel Discussion (Misc queries) | |||
Can Excel Data be simultaneously entered in seperate category list | Excel Worksheet Functions | |||
Print data in each row on a seperate sheet template | Excel Discussion (Misc queries) |