Immatoity
11-06-2012, 08:21 AM
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.
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.