oberti
12-09-2021, 07:45 AM
Hello, I am attaching my code with which I have a problem.
My problem is that with this code I open 2 files (and so far so good), when I insert the value "UT-E" in the source file, the various values are copied in a table in the second sheet.
The problem is that whatever I write in the "SOP" column after entering the letter, number or other, the code switches to displaying the second excel file. I, on the other hand, would like it to pass to the second worksheet only if I enter the word "UT-E"
I am attaching the 2 files ...... do not make fun of me .... it is trivial and maybe even long and incorrect
My problem is that with this code I open 2 files (and so far so good), when I insert the value "UT-E" in the source file, the various values are copied in a table in the second sheet.
The problem is that whatever I write in the "SOP" column after entering the letter, number or other, the code switches to displaying the second excel file. I, on the other hand, would like it to pass to the second worksheet only if I enter the word "UT-E"
I am attaching the 2 files ...... do not make fun of me .... it is trivial and maybe even long and incorrect