Macro to show who did not enter actuals for a specific day.

J

Joe

I’d like to build a macro or VB code that can show me which resources did not
enter any actuals for a given day.

I have over 60 resources that are expected to track their actual hours on a
daily basis. I want to run some sort of macro where I can see which
resources did NOT enter any hours for a given day. Any suggestion on how to
go about doing this?
 
J

John

Joe said:
I’d like to build a macro or VB code that can show me which resources did not
enter any actuals for a given day.

I have over 60 resources that are expected to track their actual hours on a
daily basis. I want to run some sort of macro where I can see which
resources did NOT enter any hours for a given day. Any suggestion on how to
go about doing this?
Click to expand...

Joe,
Take a look at the references I mentioned in your earlier post.

With respect to your specific question, I would probably loop through
all resources and use the TimeScaleData Method to examine values (or
lack thereof) for a given day.

Hope this helps.
John
Project MVP
 
Top