Hi all,

I'm using Excel 2007 and working on some printable reports from a worksheet.

The worksheet is a detailed snapshot of information from a large table of data.

Consider I had 100 unique ID's in the table for each row and the report shows detail on 1 of these rows in a different worksheet.

Is there a way I could set it up to print through a number of rows from the table without having to have loads of worksheets?

Basically, say something like 'print reports from ID's 40-50'? or 'print reports that [Meet a particular Formula]'

Is there anyway to do this?

Thanks in advance