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

[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?

 

[John]

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?

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

 

[Joe]

John,

Thank you very much for your help on both of my postings - I appreciate it.

 

[John]

John,

Thank you very much for your help on both of my postings - I appreciate it.

Joe,
You're welcome.

John