Hello Experts 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.

Try the attached, click the button on sheet A Code assigned to the button (Code, 21 lines)

Get result with code replacing the formula

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

This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close

Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.