Morning,
I need help to figure out how to solve the following problem.
To address it ASAP, i will upload a part of the worksheet, so anyone can understand it.
So here are the facts:
I am uploading 4 sheets, but in fact they are 98, so a simple lookup is not the answer.
Take a look at the rows that need to be filled:
The row "NCM" has something that might help to solve the puzzle: every worksheet starts with the first 2 numbers of the NCM, so: 0101.21.00 can be found at worksheet named 01. A NCM number 2710.19.99 can be found at worksheet named 22. and so on... Maybe this can be part of the code so it skips worksheets that won't have the information.
To make thing worse, the worksheet contains rows and lines that need to be copied... Let me show:
I need the information to return in one line, so it can continue searching and returning several NCM and respective information found inside each worksheet.
But, part of the information is in lines and the other in rows... For our luck, the worksheet is in the same format for every NCM, so, we won't have problems after solving it.
Hope we can make it happen.
Thanks in advance!
I need help to figure out how to solve the following problem.
To address it ASAP, i will upload a part of the worksheet, so anyone can understand it.
So here are the facts:
I am uploading 4 sheets, but in fact they are 98, so a simple lookup is not the answer.
Take a look at the rows that need to be filled:
NCM | Descrição | IPI | Alíquota PisCumulativo | Alíquota Pis NãoCumulativo | Alíquota CofinsCumulativo | Alíquota Cofins NãoCumulativo | OBSERVAÇÕES |
0101.21.00 |
The row "NCM" has something that might help to solve the puzzle: every worksheet starts with the first 2 numbers of the NCM, so: 0101.21.00 can be found at worksheet named 01. A NCM number 2710.19.99 can be found at worksheet named 22. and so on... Maybe this can be part of the code so it skips worksheets that won't have the information.
To make thing worse, the worksheet contains rows and lines that need to be copied... Let me show:
I need the information to return in one line, so it can continue searching and returning several NCM and respective information found inside each worksheet.
But, part of the information is in lines and the other in rows... For our luck, the worksheet is in the same format for every NCM, so, we won't have problems after solving it.
Hope we can make it happen.
Thanks in advance!