I have a sheet with a number of rows of data consisting of several
columns of fields. EX: first name, last, school, etc.

I have created 3 forms in 3 other sheets that I want to print with the
data from the data sheet.

How do I get Excel (V. 2000) to use the data and print each form with
the different student data?

I am familiar with Excel but I am a rank novice with Macros, any help
will be greatly appreciated.

Bob

You would either need to have a place where you manually enter a unique
student identifier and the remainder of the form is populated using formulas
that key off the value in that field  (such as Vlookup, Match, Index, and
that ilk).  You could select this identifier from a dropdown built with
data=.validation.

However, this would require making the selection and printing, making the
selection and printing, etc.

To automate it, you would need a macro that loops through the list of names
and populates the unique identifier film with the sheet(s) set up as above,
then print, then put in the next identifier and so forth.   Or the macro
could also populate the fields and they would not need to have formulas.

To loop through a range of cell

Sub MacroPrint
  dim cell as Range, rng as Range
set rng = Worksheets("Form1").Range("A1")  ' identifier cell
set rng1 = Worksehets("Form2").Range("A1") ' identifier cell
set rng3 = Worksheets("Form3").Range("A1") ' identifier cell
With worksheets("Data")
   for each cell in .Range(A2:A50")
      rng.Value = Cell.Value
      rng1.Value = cell.Value
      rng2.Value = cell.Value
      worksheets(Array("Form1","Form2","Form3")).Printout
   Next
End With

End Sub

Regards,
Tom Ogilvy