I have a spreadsheet with some filters, when I click on the filter to filter all say name 7 all the information in relation to that name will pop up and then I can print out the document for that user, no concerns here.
However, if I want to print out a document for like 2 or more user then I have to do this separately, and this will take some time I have a lot of users to print out and need 1 sheet per person each sheet.
Is there a way that I can click all the names so that I can print out all their information on their own sheet, is there a macro that I can use
I have taken names out and replaced with a number for obvious reasons
Hope someone can help
Bookmarks