How to create Data Entry Form in Excel – Ms Office?



How to create Data Entry Form in Excel –

Ms Office?

39 thoughts on “How to create Data Entry Form in Excel – Ms Office?”

  1. Step1) Fill number '1' in Column A
    Step2) 1st cell in Column B, Fill number '1' (if you have header start from 2nd cell)
    Step3) 2nd cell in column B, copy this formula =IF(B2<4|B2+A2|1)
    what happens is, after every 4 number it'll auto reset to 1

    Wish I can draw a table in comments section
    Good luck. It's slick and works very well

    Reply

Leave a Comment