Hi All .. looking for some help with printing

I have a workbook that comprises of two principal sheets.

The first is a transaction list of people and various numeric measures, the second is a formatted sheet that analyses the transaction list and produces an output report containing various charts.

At the moment, I manually select the record that I want to print and then I print the report page. I repeat this for each record in the list. Rather than printing to printer I am 'printing' to PDF via Adobe Acrobat. Each time I create a report I set the file name to be a combination of the person's name and an element of the unique transaction id that is held in the transaction file.

What I would like to be able to do, is to automate the printing of a series of reports.

Ideally I would like to set a start and finish transaction number for the transaction range (they are stored sequentially from 1 to n) and for the code to walk from the first to the last, passing the transaction reference to the report sheet (which actions various lookups) and for the output file to be created in a nominated directory with an automatic name.

I hope that this makes some sense, can anyone give me some pointers as to how best to go about this?

Thanks again in advance

A