Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Paul Smith
 
Posts: n/a
Default 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   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL - LINKS cannot easily get list of all links & names in book Tuba Joe Excel Worksheet Functions 1 September 29th 05 10:33 PM
Import data from files with different names to EXCEL D'base. thunderfoot Excel Discussion (Misc queries) 2 June 10th 05 11:05 AM
How do I capilize a list of names on excel? vrajna Excel Discussion (Misc queries) 4 April 20th 05 08:41 PM
How do I put a list of names and e-mail addresses in excel so tha. trav Excel Discussion (Misc queries) 4 December 2nd 04 03:56 AM
How do I import a Windows Explorer list into Excel? Gord Dibben Excel Discussion (Misc queries) 0 December 1st 04 11:20 PM


All times are GMT +1. The time now is 01:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"