Export to Excel by category

[Ron]

Hi,

I would like to automatically create Excel sheets according to field values
in a table.

e.g. a sheet for all records where name = 'Dave' and another sheet for all
records where name = 'Fred'.

Any help appreciated.

Ron.