PDA

View Full Version : Lable the last know person to entra data to a cell from a list of names, populate dat



m.paterson1
05-23-2016, 12:06 PM
I have been making a Plant list to label which site has which tool but I am struggling to get the last known person who had the tool to go into a cell, and for insurance purposes I need to know what the last date the tool was seen. I can populate the date but when the data returns to 0 Which would mean the tool is either lost or stolen the date disappears as well.

I have attached a sample of the book.
Cells B to F use V lookup from another book to find where the tool is and then puts a number in the cell as per the name number B=1 C=2 etc, then conditional formatting highlights that cell Red to show a list of tools and who has. But this dose not account for when the cells are empty so I need Cell I to show the last person to use and Cell H to show the last date seen.