Excel Form printing multiple selections

[ebisabes]

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

 

[SkipVought]

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]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[ebisabes]

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?

 

[ebisabes]

I'm wondering if the only way to do this would be a Mail Merge with Word.

 

[SkipVought]

faq68-4223

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

 

[ebisabes]

Thanks Skip. You ROCK!

 

[SkipVought]

Post back if you need clarification or help.

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