Posts by frpu

    Greetings,

    I have to insert a row according to the date inserted in Textbox1 an the value in Column C.

    The row be inserted above the cell if it satisfies both condition while if the value of column C is missing, it must be inserted after the last date egual to Textbox1.

    Thanks.


    Before----------------------------------------------------------------------- After

    A--------B--------C .................................................................A----------B--------C


    1 01/01/2021 CD..............................................................1 01/01/2021 <----------row inserted

    2 ------------------------------------------------------------------------ 2 01/01/2021 CD

    3 05/02/2021--------------------------------------------------------- 3 -----------------------

    4 05/02/2021--------------------------------------------------------- 4 05/02/2021

    5 05/02/2021 CD-----------------------------------------------------5 05/02/2021

    6 ------------------------------------------------------------------------ 6 05/02/2021 <-----------row inserted

    7 07/03/2021 CD----------------------------------------------------- 7 05/02/2021 CD

    8 -------------------------------------------------------------------------8 -------------------------

    9 10/05/2021----------------------------------------------------------9 07/03/2021 CD

    10 10/05/2021-------------------------------------------------------10 ------------------------

    11 ----------------------------------------------------------------------11 10/05/2021

    12 ----------------------------------------------------------------------12 10/05/2021

    13 ----------------------------------------------------------------------13 10/05/2021 <-------------row inserted

    What I need to realize is the FINAL TABLE situation see File. I added the lines with the missing numbers up to 20 manually I have to do it with some code. Thank you.

    Code
    The data is structured like this also in the original file, only data is missing in the white columns for obvious reasons. The numbers in column K are protocol numbers.
    The insertion of missing numbers must take place according to the data entered in the textboxes.

    Hello,


    I have to insert rows in function of the missing numbers in column K and the date in column B.

    For example, I have to enter the number 4, the line must be inserted under the number three but the date can be 07/01/2020 or 08/01/2020.


    Thank you