1-vba insert line by date and reason 2 - insert row by date and by number

[francesco19]

Attached file

[bsalv]

you give not very much information (in english)
so see rows 5:36 and the green textbox
enter a date like dd/mm/yy for example 05/01/21 for 5 januari 21

[francesco19]

Test the attached file.
On the other hand, I find it difficult to enter the missing invoice numbers in column F which are not sequential.
In the original file they are inserted through a listbox that is not here but I have to do it as if I inserted a normal line based on the date in textbox1 and the number in textbox2.
For example: number 15 is missing -
the insertion date goes from 01/16/2021 to 01/27/2021, the number 15 corresponds to the same row in column K obviously after 14 and so for 16 and 17.

Please Login or Register  to view this content.