Hi, I know there are a lot of discussion on inserting static date using vba, but I need something different. i need one that would insert a dummy date whenever the next cell is empty.
to be more specific, I need a code to reflect the date of the respective surveys in the respective column whenever i input the result, but will display a dummy date when the result is blank. (the surveys are done on ad hoc basis, so some people might have done 3, but some have not even started on it).
I intend to use pivot table to count the number of the survey done over time, so i can't leave any blank in the survey date column.
<tbody>
</tbody>
appreciate it if anyone can assist or suggest something for me please.
to be more specific, I need a code to reflect the date of the respective surveys in the respective column whenever i input the result, but will display a dummy date when the result is blank. (the surveys are done on ad hoc basis, so some people might have done 3, but some have not even started on it).
I intend to use pivot table to count the number of the survey done over time, so i can't leave any blank in the survey date column.
Name | Survey 1 Date | Result | Survey 2 Date | Result | Survey Date 3 | Result |
<tbody>
</tbody>
appreciate it if anyone can assist or suggest something for me please.