harvesting text

iamkeen

Board Regular
Joined
May 7, 2005
Messages
55
hi,
i have a spreadsheet that consitsts of 12 columns and unlimited rows- one of the columns states either yes or no.
i want to when the spreadsheet is first opened show me all the items that have a yes by the side of them. ie harvest all the yes items so that the entire row is shown in a textbox. how would i go about doing this
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Damon Ostrander

MrExcel MVP
Joined
Feb 17, 2002
Messages
4,239
Hi iamkeen,

I'm wondering if just adding a filter to the yes/no column and using this to just display rows with yes in the column would accomplish what you want? This is very easy, and could be set up to always filter on yes when the workbook first opens.

Damon
 

Watch MrExcel Video

Forum statistics

Threads
1,113,990
Messages
5,545,370
Members
410,679
Latest member
rolandbianco
Top