Panda
04-19-2011, 06:18 AM
Hey all,
Does anyone now some vba code to search for a blank cell within a column based on two conditions?
What I want to do is search a worksheet for an employee name, find their work status (are they in or out), if they are out AND if the Time Booked column is blank then enter the formula =Now().
The reason why I need this is because the worksheet records every time an employee signs out so there will me multiple occurrences of the same employee’s name.
Attached is an example of the spreadsheet that I am trying to work on
Any help would be greatly appreciated.
Thanks
Phil
Does anyone now some vba code to search for a blank cell within a column based on two conditions?
What I want to do is search a worksheet for an employee name, find their work status (are they in or out), if they are out AND if the Time Booked column is blank then enter the formula =Now().
The reason why I need this is because the worksheet records every time an employee signs out so there will me multiple occurrences of the same employee’s name.
Attached is an example of the spreadsheet that I am trying to work on
Any help would be greatly appreciated.
Thanks
Phil