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

Copy entire row from another sheet onto first sheet if a unique text matches 1
Copying info from worksheet to worksheet if info matches 2
Automatically copying data from sheet1 to sheet2 2
Copy data automatically from sheet1 to sheet2 0
Click one cell sheet1, display all related recs on sheet2 1
What is the most straightforward (elegant) way to write this formu 5
Index Match to ignore blank cells 0
Move entire row to another sheet and deleting the old row only. 0

Top