EXcel, create a list from extracted data, Conditional

G

graham gordon

Hi

Hope someone can help with this.


I have 5 sheets, with various data,

If on a 6th sheet I would like to create a
list of specific data (Cells) found on the 5 other pages
(Each page contains approx 200 rows of data)
How could I do this?

The Condition would be that the word "NO" would be contained on a
particular row of cells somwhere on the previous
5 pages


tks

Graham

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 

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

A Huge Conditional Format Challenge.... 2
How to copy row data from Sheet2 to Sheet1 based on Conditional Date 2
Create if partial match then copy and paste data from one cell to another 1
Excel 2003 VBA In directory Open Spreadsheets Extract data 1
>3 Conditions for Data Validation for a List 6
How to extract data from a spreadsheet into a form/create form from spreadsheet data 3
Load data from Word into Excel 7
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5

Top