Filling in blank cells in the report

Filling in blank cells in the report

Hello everyone!

We have a customer based on the medical field and we currently have a NCR document right now about not filling in blank cells on the report page. Basically a blank cell in medical industry report means missing data.

So is there a way or a visual basic code that will auto fill the blanks with "N/A" to show that we are not missing data?

Heres an example :


All striked through cells has to contain "N/A"