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. |
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. |
All times are GMT +1. The time now is 12:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com