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