Hey everybody. I am trying to create a function that would pull data to the "Overview" sheet, from "GMF" sheet, when column D has 30 or fewer days left. I created an IF function that does show the names when criteria is met, but leaves a blank row when criteria is not met. Is there a way to skip the blank rows in the "Overview" sheet so it looks neater? The final "GMF" sheet will have about 150-200 names in it. Is it also possible to pull the column with the name (column A) and the column with the days remaining (column D), similar to what is in the "Sample_Sheet" sheet. This is basically what I am trying to make it look like in the "Overview" sheet. The "Overview" sheet would be printed on monthly basis for employee requalification.
Thank you for any help!
Bookmarks