I am trying to get the invoice number from Sheet A which contain "-Total" to the B Sheet with the help of a formula. I am getting a lot of blank cells in sheet B in between rows. After many attempts I am not able to get it with a formula. I am not so good at coding. I need your expertise in 2 issues to get the values with the help of a code.
I need your help to get the full values of the invoice number cell even if it starts from 0 for instance, 001-Total in Sheet A should display as 001 in the B sheet. If possible get the ID along with the Invoice number.
I would really appreciate it if anyone can help me to correct the issue and instead of a formula. make it possible to get the result with the help of a code.