I have tried many things and I know a filter on the columns would do it but
then I would need to copy and paste to fill reports:(

I have a course register with a heading title for each column.
Each row is a unqiue record and I can limit the rows to match the amount of
colmuns

I have 3 reports that need to be filled from the row data with the selection
critera of (Rpt1) by Dept, (rpt2) by Course and (rpt3) by name

Below is an example of the register:

Name Dept Course Cost Status ID
colin admin word £1.00 booked trn001
Jane IT excel £2.00 reserved trn002
Colin admin excel £2.00 reserved trn003
etc
etc

The closest i got is with a vlookup but then cannot figure out how to check
each row.

many thanks and really desperate for this.

Cheers
Colin