Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I import a list of names into a separate form that prints .
I have a list of names on one worksheet.
I have a second worksheet that is basically a form. I would like to print out each page with the names from worksheet one without having to do a new worksheet for each tab. Somehow, I should be able to get the list to printout each name on a separate page showing the pertinent data. |
#2
|
|||
|
|||
Paul,
If the names are on sheet1 in cell A1:A100 and the form is on sheet2, with the name going into cell A1, something the macro below will work. HTH, Bernie MS Excel MVP Sub PaulPrint() Dim myCell As Range For Each myCell In Worksheets("Sheet1").Range("A1:A100") With Worksheets("Sheet2") .Range("A1").Value = myCell.Value .PrintOut End With Next myCell End Sub "Paul Smith" <Paul wrote in message ... I have a list of names on one worksheet. I have a second worksheet that is basically a form. I would like to print out each page with the names from worksheet one without having to do a new worksheet for each tab. Somehow, I should be able to get the list to printout each name on a separate page showing the pertinent data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
Import data from files with different names to EXCEL D'base. | Excel Discussion (Misc queries) | |||
How do I capilize a list of names on excel? | Excel Discussion (Misc queries) | |||
How do I put a list of names and e-mail addresses in excel so tha. | Excel Discussion (Misc queries) | |||
How do I import a Windows Explorer list into Excel? | Excel Discussion (Misc queries) |