Display information from other worksheet

F

Frustrated

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.
 
O

Otto Moehrbach

Apparently you want to display the contents of one cell if another cell has
"yes" in it, but you provide no information about the relationship of these
2 cells. Post back and describe the layout of your data. Things like this
is in that cell/row/column, that is in the other cell/row/column. And if a
"yes" is in that cell/row/column, I want to display this cell/row/column.
HTH Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiply with Vlookup value from another Worksheet 0
If yes then display information in cell 2
Displaying Returns from another worksheet that change? 3
merging duplicate donors and donation amounts from different years 8
Display relevant information from excel sheet into form 3
Display entire number in cell 3
Multiple worksheet summary 4
Display information being cut short 1

Top