I need to display information from another worksheet that would fill up a
cell block the size of 50.28 x 532 (about 5 Columns wide and about 37 rows
long) I am able to display the information from only one entry, (by cell
E2=[worksheet.xls]Master'!H27). but I need to display information from only
one entry at a time in this Display box only if the entry field is yes. And
only one entry will be answered yes at a time. The problem is there can be
as many as 500 entries on this worksheet but I want to display only the entry
that includes a yes cell.