Extract Information and Automatically populate another table

Hi everyone,

Not sure this is the correct place for this request (have moved it from another area), or if I have described it correctly, but essentially, I am wondering if it is possible to populate a table on a worksheet with information from another worksheet dependent on one column? I have attached a working example to try and explain.

On the Compliance Matrix sheet, column F states whether the clause is compliant, non-compliant, partially compliant, removed or updated. If the clause is non- compliant or partially compliant, I would like that row and that information to automatically populate the table on the Issues List sheet. I would be then able to work through those issues, and when it becomes compliant, I would update on the Compliance Matrix sheet and it automatically disappears from the table of issues.

I would then like to link that table to a Powerpoint, so that the issues can be presented to management and burnt down appropriately.

Is this something that is possible? I would welcome any other ideas as to how best to do this, or improve the document.

Thanks so much in advance for your help.

duplicate

https://www.excelforum.com/excel-pro...ml#post5785639

Yeah...thank you! That is why I stated I have moved it from another area!

don't duplicate, ask moderator to move

Thanks again for your help

Hi...and thank you for your response.

When I open the file, it looks like it is doing the right thing, but I have tried two things; firstly, adding supplier comments in the Compliance Matrix sheet so that the detail shows up in the Issues List; and secondly, changing a compliance tag from C to NC in column F of the Complaince sheet, again to see if the table on the Issues List is updated. On both occasions, the table displays "#NAME?" in each cell of the table.

Am I doing something wrong?

Originally Posted by tanasedn

No, you don't.
It means that you don't have those functions in your Excel version.

Is there a specific function I should check versions for? I will attempt to upgrade Excel so that I have the function you are talking about.

But if i use the simple filter option on the main sheet, can I still get that date to automatically update another table? Ultimately, I want to link the table to a separate reporting document in a PowerPoint. Is there another way I could do this?