Writing text into cloumns

Is it possible to write ERWR on the column of cells this way? I’ve tried write range but all it does is replace the top most cell every iteration. I’m also trying write cell but I have no idea how to make it write down a cell every time
Annotation 2021-05-20 163303

Yes it is may you please share the sample excel

Identifier No. tracking for forms.xlsx (15.2 KB)

till want length you want to write it 10 row 20 row?

it’s based on the number of forms that’s going to be processed monthly. So I need an iteration based on the number of forms

DataColumnFilling.zip (13.9 KB)
Please find the attached code it will help you if not please let me know