HI everyone
I'm new in vba excel but trying to use it to help me in my job , so I already create one to save my time by copy paste data from one excel sheet and fill it in another excel sheet designed forms.
It's working great, till last code for counting total used rows in each form , It's working with first form but forms below what every their quantity not working I couldn't figure out

here is the code for first form which is working fine

Set rngk = ws2.Range("ae45")
fil = ws2.Range("L50:L68").Cells.SpecialCells(xlCellTypeConstants).Count
rngk.Value = "NUMBER OF DRAWINGS SPECIFY ON THIS SHEET " & fil & ")"

and here is the second one to do the same in below forms

Set rngk1 = ws2.Range("ae45").Offset(g * a, 0)
fil1 = ws2.Range("L50:L68").Offset(i * a, 0).Cells.SpecialCells(xlCellTypeConstants).Count

rngk1.Value = "NUMBER OF DRAWINGS ON THIS SHEET " & fil1 & ")"

i=18
g=36
a= 1 to cnt ( which is no of forms to be created)INFO.png