Hi Debi

Could you not just use Autofilter.
Mark your range of headings, then Data>Filter>Autofilter select the
drop down on column D and select NO
You will then see a filtered list of just those lines.
Copy the block of data and paste to your other sheet.

Regards

Roger Govier



Debi wrote:

>Would someone have an example of how I would use vlookup to produce the
>outcome from the if statements that are listed below. I want to be able to
>check one cell in ever row, row by row intil there are no more entries:
>Copy the data in the row from the first worksheet “Today’s Entries”
>Where the cell tested true
>To a different Worksheet “Outstanding List”
>· If in worksheet “Today’s Entries” cell “D5”= YES then
>Go to D6
>· If in worksheet “Today’s Entries” cell “D5”= NO then
>Copy entire row (“Today’s Entries” A5:AB5) then
>Go To worksheet “Outstanding List A10”
>· If in the worksheet Outstanding List A10=” “ (blank) then
>Paste (“today’s Entries” A5:AB5) in Outstanding List A10:AB10 then
>· GO TO “Today’s Entries D6 else
>· If Outstanding List A11=” “ (blank) then
>Paste (“today’s Entries” A5:AB5) in Outstanding List A11:AB11 then
>· Go To Today’s Worksheet D6 else
>If in worksheet “Today’s Entries” cell “D5” = “ “ (blank) then
>· Stop.
>The desire is to check an entire worksheet for a No in Column D line by line
>if true to copy the entire row associated with the Cell (i.e. D1=NO) to a
>completely different separate worksheet if not true to check the next cell
>and so on,
>When the test in not true go to the next cell to check if it is true and
>follow same paths until you the next cell being tested is blank then stop the
>checking.
>
>When you paste the row from the first worksheet into the second on
>the next time you have a row to past the second worksheet
>will need to go down the first empty row
>
>Step one cell down from the previous Cell Tested
>
>
>