Hello.

I require help for making the following table. Consider that I have three sheets in an excel workbook.
> The first sheet is the summary page. The next two are say Subject1 and subject2.
> Each of these subject pages has a table with two columns - bookname and status.
> 'Bookname' is regarding the name of the book and 'Status' can be Yes or No - indicating whether I have started the book or not.

Therefore, at any given point, in subject1 and subject2, there will be several books and each of them will have Y or N assigned to it.

That being the case, I just want to know how I can show only those books - present in subject1 and subejt2 sheets - which are marked 'Yes' in the summary page. That is, I want in the summary page a table which shows which book i am reading currently.

I hope I have posted this question at the right place. Please let me know if I have to move it to appropriate forum.
Thanks