macro to filter on each unique record and print range

[Immatoity]

hi all

sorry I have searched on the term "filter" but not yet come across this.

I have a table, with headers, populated columns A:AG, rows vary per fortnight ( when this is completed fresh)

there are autofilters on already. I need a macro to filter and select each unique record in column B "Service User" and print the resulting range for each ( approx 40 unique service users). I want a "button" for the user to press to do this.

I need another macro to do exactly the same but this time on column D "Staff" (currently 75 members of staff).

The end user is currently manually filtering and selecting range and pressing print, so I want to automate if possible..

thanks

PS I can put a sample up if required.

[snb]

Please do....

[Immatoity]

hi thanks..example attached... not that many rows in..but lots in the "real" file

[Immatoity]

Still stumping me this one and being asked about it. Any help greatly appreciated