Excel - How to print by some rule/criteria ?

[tasic89]

I would like to print some file in Excel, now I always need to first do a filter, than print.

example given - I have City, and than in one city I have like 10 streets. 1st street have 10 people, 2nd street 5 people etc.

I would like to maybe crate some like criteria, like unique code for each of those people, like in 1st street all 10 have unique code. 2nd street all 5 have unique code etc

And I would like to print out all people but by that unique code. In one go. Like to automatically do a filter and print, or to do some kind of print but with condition. I don't want to filter, than print, than filter again and print ...

 

[OaklandJim]

I can't promise that I can do this but I'll try. If not me then possibly other people who are smarter about Excel.

If you want assistance you are more likely to get help if you help the helper so they do not need to guess about or recreate your data.

Pictures are not very helpful. If the data is not confidential post a link to your workbook. If necessary you can enter fake-but-realistic data before providing the link. Put the file on Dropbox, Box, 1Drive, Google Drive etc. Use the link icon above the Mr Excel message area. Make sure that other people can access the file!

Or, consider sharing relevant data using Mr Excel's excellent XL2BB addin that enables you to post a portion of a worksheet. See XL2BB - Excel Range to BBCode for details.

It also helps if you show us the result that you need.