Hi I have a simple monitoring table with 7 columns (Date,Time out, time in, Item name, Borrower, Contact# & Status).
The column 'Status' has a dropdown list that contains 'Returned' & 'Not Returned'.
What I wanted to happen is whenever the 'Status' is in 'Not Returned' status, I want to display the cell data in the 'Borrower' column in a different cell.

say this table:

DATE TIME OUT TIME IN ITEM BORROWER # MOBILE# STATUS
February 19, 2014 10:30 AM 11:19 ITEM1 BORROWER1 XX-XXX-XXXX RETURNED
February 20, 2014 9:45 AM ITEM2 BORROWER2 XX-XXX-XXXX NOT RETURNED

I want the cell data 'BORROWER2' to be displayed in a different cell.

Hope you understand what I am trying to say.

Your help will be appreciated.

Thank you.