Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Form printing multiple selections

Status
Not open for further replies.

ebisabes

Technical User
Aug 11, 2006
71
US
If I have 2 tabs, one a list of data and the 2nd a form with links from the data list:

is it possible to print a new form for each line of data? Please let me know if I need to compose my question better.

ebisabes
 



Hi,

If your "form" is an ordered table, you might be able to use Data > Subtotal... and use Pagebreal between groups, where YOUR groups are groups of ONE.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
I don't believe my form is the ordered list you refer to. When I say 'form' I mean a strategically placed area. For example,

say I had the image of a W4 on one tab with a list of employee data on another tab: how would I link the data to show on the W4 and print a new W4 for each employee data.

is that a good example?
 
I'm wondering if the only way to do this would be a Mail Merge with Word.
 





faq68-4223

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 



Post back if you need clarification or help.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top