![]() Hopefully you understand on what is desired. if catagory input criteria changed Z then it will be 1 only, same way if I change row 3 catagory as Z than keeping same date (1-Jan-20),than Voucher no should be 2 as 1 as my date is older then row 2,3 based to catagory. Click Module > Insert to insert a Module window, and copy the below VBA into the window. In cell F1 input the number 1, and input 2 in cell F2. ![]() For example, I have a worksheet comprises A1:E9, you can use column F. ![]() ![]() You need a blank column adjacent to your data. Press Alt + F11 keys to open the Microsoft Visual Basic For Applications window. This method is an easier but roundabout to insert blank rows between exiting rows. based on the date sequence, my row “Date” input for particular transaction might change any any given point, suppose row2,3,4/Catagory X has Date as, than my sequence for voucher Sr will be 1,2,3, but if I change row4 Date input to by keeping the same catagory as X than my Voucher should have Sr. There is a VBA code can create another shortcuts for inserting blank row. I just came accross your site, Indeed its informative, however I am looking for one of the solution/ the way to insert serial no at column based to Random input on multiple criteria at row/column cellsĮxampls, I am trying to maintain a Voucher Series with Alpha numeric as Sr.No.
0 Comments
Leave a Reply. |