Excel 2003

  • 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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!