Ok... so here is my issue with Excel that I am having. I have to track resources within my department.

Page 1 will have a list of the resource, the name of the person, the out date and the date it is returned.

On Page 2, I want to be able to see just one record of who currently has it (Page 1 will have a running record of everyone who has taken it out within a year). What I want to do, is have a formula that if Page 1 Col B contains a date, but Col C is blank, that this information get updated on page 2.

Is this doable? I want it easy enough to be able to provide Managers will updates as to what is currently out and not returned...

Thanks!