If Sheet1 column is marked complete, display entire row on Sheet2?

C

CDZ

I'm not sure of the best way to go about doing this in Excel 2003

Lets say, on Sheet 1, I have a row of client projects. On them, I mark
column L with "Complete" for complete.

I would like Sheet 2 to only display clients from Sheet 1 that have
the "Complete" in column L.

Any ideas?

Thank you
 

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

Excel VBA to move cells to sheet2 based on selection in sheet1 0
Compare identifier columns from 2 sheets - remove rows that are dups 2
Copying info from worksheet to worksheet if info matches 2
Match and delete rows on two different sheets from reference numbers 4
Finding the most recent date - Excel 2K 3
Click one cell sheet1, display all related recs on sheet2 1
Refernce 2 sheets & same columns & rows 8
Excel Challenge: Copy and pasting sheet1 to sheet2 3

Top