I am working on creating an automated form in Excel that people can submit entries and it will record on a different tab. I got everything up and running, the only problem that I am facing now is that every time I am entering the details, it is overwriting the previous entry instead of the new entry going on to the next row. Any idea where I am getting this wrong? The row variable code I currently have is:
Dim sh As Worksheet
Dim iRow As Long
Set sh = ThisWorkbook.Sheets("Database")
iRow = [Counta(Database!A:A)] + 1
With sh
All help is appreciated!!
I have tried all sorts of things to correct this problem but none have worked.
