B
BenjiHarshbarge
Once again I am baffled!
I need to keep track of projects that get checked out to be updated.
Each sheet is a different project.
In column B I have when the project was checked out.
IN column C I have the date the project was checked back in.
The formulas I am currently using are:
Column D:
=TRIM(IF(B9<>"","out","")&" "&IF(C9<>"","in",""))
which gives :"out" if not checked in and "Out IN" if it is.
Column E:
=IF(B9>C9,"OUT","In")
This tells me if the project is "Out" or "In" based on a dat
comparison.
Both basically do the same thing.
What I am trying to find out is how I can build a macro to search t
find the projects that are still out
and at the same time tell me which projects should be worked on nex
based on the date in column C
So far the only macro I have is:
Range("e7").Select
Range("e7").End(xlDown).Find("Out").Select
Which finds the last instance of the word "OUT" in a column.
Am I making this more dificult than it is?
I would appreciate any help!
Thanks!!
Ben H:confused
I need to keep track of projects that get checked out to be updated.
Each sheet is a different project.
In column B I have when the project was checked out.
IN column C I have the date the project was checked back in.
The formulas I am currently using are:
Column D:
=TRIM(IF(B9<>"","out","")&" "&IF(C9<>"","in",""))
which gives :"out" if not checked in and "Out IN" if it is.
Column E:
=IF(B9>C9,"OUT","In")
This tells me if the project is "Out" or "In" based on a dat
comparison.
Both basically do the same thing.
What I am trying to find out is how I can build a macro to search t
find the projects that are still out
and at the same time tell me which projects should be worked on nex
based on the date in column C
So far the only macro I have is:
Range("e7").Select
Range("e7").End(xlDown).Find("Out").Select
Which finds the last instance of the word "OUT" in a column.
Am I making this more dificult than it is?
I would appreciate any help!
Thanks!!
Ben H:confused