Hi Debi

Could you not just use Autofilter.
Mark your range of headings, then DataFilterAutofilter 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 €œTodays Entries€�
Where the cell tested true
To a different Worksheet €œOutstanding List€�
· If in worksheet €œTodays Entries€� cell €œD5€�= YES then
Go to D6
· If in worksheet €œTodays Entries€� cell €œD5€�= NO then
Copy entire row (€œTodays Entries€� A5:AB5) then
Go To worksheet €œOutstanding List A10€�
· If in the worksheet Outstanding List A10=€� €œ (blank) then
Paste (€œtodays Entries€� A5:AB5) in Outstanding List A10:AB10 then
· GO TO €œTodays Entries D6 else
· If Outstanding List A11=€� €œ (blank) then
Paste (€œtodays Entries€� A5:AB5) in Outstanding List A11:AB11 then
· Go To Todays Worksheet D6 else
If in worksheet €œTodays 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