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.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Survey 1 Date[/TD]
[TD]Result[/TD]
[TD]Survey 2 Date[/TD]
[TD]Result[/TD]
[TD]Survey Date 3[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Survey 1 Date[/TD]
[TD]Result[/TD]
[TD]Survey 2 Date[/TD]
[TD]Result[/TD]
[TD]Survey Date 3[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
appreciate it if anyone can assist or suggest something for me please.