run report that uses a set of dates

  • Thread starter Thread starter BenjiHarshbarge
  • Start date Start date
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 date
comparison.

Both basically do the same thing.

What I am trying to find out is how I can build a macro to search to
find the projects that are still out
and at the same time tell me which projects should be worked on next
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:

Attachment filename: projecttracking.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=384183
 
I'm not sure I'd use a macro.

I think I'd do a combination of Data|Filter|autofilter and sorts.

Select your range and then Data|filter|autofilter.
then you can use the dropdown arrows to show any combination of out-in's that
you want. (and you could filter nicely to check to see if the equivalent
formulas really are equivalent.)

And if there's only a little data, then maybe the filter will show you what
should be worked on next.

But if there's lots, then just sort the data by one of those date columns
(descending so that it appears at the top of the list).

filter by whatever you need to filter by and get your list.

You could even filter your data and print it and review the list of priorities
at your next workload meeting.
 
Back
Top