Full Automatic Visitor entry Form | Visitor data entry register in excel

[@ar_1294]

In ID card box u can Conditional formating for compulsory 15 characters entry

[@ar_1294]

In mobile entry box u can Conditional format for 11 digits or 12 characters compulsion

[@crimsonk91]

How could I change the CountA to reflect how many visitors per day each day instead of total?

[@nasiritsolution]

You can add if function with the same formula if(cells=date function), count,.... I will send you a perfect video as per your requirements

[@crimsonk91]

@@nasiritsolution Thank you for the help, I love your videos.

[@nasiritsolution]

ruclips.net/video/Gsr6nWM675s/видео.html

[@nasiritsolution]

ruclips.net/video/Gsr6nWM675s/видео.html

[@venkatesh620]

Can I get this sheet for reference.

[@nasiritsolution]

yes i will check and attach as soon as possible

[@Mrmuhammadsajawal]

Hi bro! i have some issues, when i add new entry, it doesn't increase it just rename previous one .

[@nasiritsolution]

during the (record macro) when you pasted data and move cursor to right side in empty cell then go to entry sheet
if you work on (Ctrl+T) table then insert row above and your cursor must be in the insert row first cell (entry first cell

[@Mrmuhammadsajawal]

@@nasiritsolution thanks bro, also let me know after completing the whole process, can we make "student registration" application? And how?

[@nasiritsolution]

ruclips.net/video/Gsr6nWM675s/видео.html

[@nasiritsolution]

@@Mrmuhammadsajawal ruclips.net/video/HH5LHsOWhRc/видео.html

[@lalitpatil1428]

Hi