Hi Experts,
Looking for an solution to add a ROW for missing dates in a Range: Formulas or Macros will do.
I have employee details who are mapped to different projects in a Financial Year (01-Apr to 31st Mar), however there could be a possibility that employee was not been part of any project for a shorter period in the Financial Year. I will have details only for the projects there were mapped and not for the dates they were idle.
Hence I need to insert a Row against each of those missing period and map it as idle for those missing period in a Financial Year.
Regards,
Harish S
Looking for an solution to add a ROW for missing dates in a Range: Formulas or Macros will do.
I have employee details who are mapped to different projects in a Financial Year (01-Apr to 31st Mar), however there could be a possibility that employee was not been part of any project for a shorter period in the Financial Year. I will have details only for the projects there were mapped and not for the dates they were idle.
Hence I need to insert a Row against each of those missing period and map it as idle for those missing period in a Financial Year.
Regards,
Harish S