Creating Files from list?

[car99r]

OK, this may not be possible but I figured if it is you members here would know the simplest way to do it.

I have roughly 250 employees. I have to create an evaluation feedback form for each employee. This form will contain has to contain the employees name and ID number.

I have a list of all employees with their ID numbers in a separate excel file.

I was curious if there was a way to do this using functions instead of hand entering each one and saving as...

This is the list:

and the eval form:

as you can see on the eval form I am entering each persons name into cell C2 and ID number in H2.

Can anyone think of a faster way to manipulate the data?

Thanks again ahead of time!

 

[BobUmlas]

in some cell which is outside the print area, enter 2. Let's say that's cell Z1.
in cell C2, enter =INDEX(Sheet1!B:B,Z1) and in cell H2 enter
=INDEX(Sheet1!A:A,Z1)
Print.
Then change the value in Z1 to 3, Print. then 4, print, etc.
(This assumes your data sheet is named Sheet1. Change if needed.
Obviously, VBA makes this even simpler:

Sub PrintAll250()
'With the form sheet active
For i=2 to 250
Range("Z1").value=i
activesheet.calculate
Activesheet.Printout
DoEvents
Next
End Sub

HTH
Bob Umlas
Excel MVP

 

[Yahya]

and another way
you can use word --Mail Merge
with a list of names form Excel to Print it also