Looking for a macro that can identify the pages which have a specific table cell blank

[Calin Daian]

In my project space, I have a list of pages - each page is a separate requirement. The content of each requirement is organized in tables. One of these tables on the requirement page has a row on which a macro lists incoming links to the page (specs pointing to this requirement). All links pointing to this page are listed next to 'PSD ID(s)'.

Below, the left table has no incoming links (no entries in the table), while the right table has 2 pages pointing to it.

 

At the project level, I need to list all of the pages for which this table cell is blank (meaning that no links are found pointing to the page).

Right now I'm doing this work manually (open each req, seeing if it has any links, create a list of pages with no incoming links). How can I streamline this?

[Andrey Khaneev [StiltSoft]]

Hello Calin,

You can use Table Filter macro to filter PRD column with dropdown filter by empty value.

[Calin Daian]

Andrey, thank you for your answer. I tried the Table Filter macro but I think I'm looking to accomplish something slightly different. I updated my question body and put up a couple of sample screenshots to make my request more clear. If you wouldn't mind giving it another look I would appreciate it. Thanks.

[Andrey Khaneev [StiltSoft]]

You can use Page Properties Report macro to collect all the tables in one with links to each page and then filter it with Table Filter if needed.