Is there anyway i can populate a new page to show some kind of filtered information based on whether a series of cells are populated yes or no.
I want to have a list of cells that each have the option "yes" or "no".
I then want to be able to run a macro or some kind of automation where it looks for all of the "Yes" and then only shows the information for those options on the next page.
I want to have a list of cells that each have the option "yes" or "no".
I then want to be able to run a macro or some kind of automation where it looks for all of the "Yes" and then only shows the information for those options on the next page.
