Training Report - VB & IF Function help required

I have a training report that basically dumps data in an excel file from our training database and we need to manually manipulate the results to get what we want. I've been trying to cut out the manual manipulation of the data as there are over 10,000 rows for each of our offices and I need some assistance.

1) Firstly, the data for each employee only appears once (Full Name, Emp No & Job Title). I added the following to VB and can get the First name to auto populate the rows that follow but can't amend to do the same for Emp No & Job Title. Can anyone assist?

Please Login or Register  to view this content.

2) I want to identify courses with an expiry date less than or equal to 3 months from today. I can get this to work by inserting a Refresher Needed column with IF(F3<-TODAY(),"TRAINING NEEDED","COMPLETE") however if the expiry date field is blank I want the Refresher Needed column to be blank also. I tried to use ISBLANK but with no success.

Appreciate any assistance with these!

T

I'm not quite clear on whether column G was meant to be the "refresher needed" column or if you wanted a new column added, but something like this should do:

Please Login or Register  to view this content.

This will add "Training Needed" or "Complete" to column H if the expiration date is not blank. If you wanted that data in column G instead of H, change the 8 in the two instances of:

Please Login or Register  to view this content.

...into a 7.

To follow up on my earlier post, if you want the Training Needed portion to be done by formula, not VBA, then use this for the code:

Please Login or Register  to view this content.

And for the refresher, you can put whichever best suits your definition of "3 months" in row 3:

Today's date 3 months ago: =IF(F3="","",IF(F3<=DATE(YEAR(TODAY()),MONTH(TODAY())-3,DAY(TODAY())),"Training Needed","Completed"))
OR
90 Days ago: =IF(F3="","",IF(F3<=TODAY()-90,"Training Needed","Completed"))

My pleasure, good luck!