09-06-22 01:09 PM
Hello masters and mistresses!
I have a problem, well, I have a defined data called "material" and only the value called "center" is in the worksheet, example:
Column C "Material" : "VALUE A", I need to check in column H to Z if it has the center "H001".
The problem is that it is taking a long time and the process sometimes falls because the columns are big.
I had seen something related a while ago here in the community but I couldn't find the topic, someone had made available a code in C# or VBO that helps with this issue.
Can someone help me?
Thanks
Answered! Go to Answer.
09-06-22 09:20 PM
|
09-06-22 01:43 PM
[Material]='Valor A' AND ([CENTRO1]='H001' OR [CENTRO2]='H001' OR [CENTRO3]='H001' OR ...etc)
09-06-22 03:48 PM
Hi John! Thanks!
but there's only one problem
the centers are very today the worksheet has 177 columns
And tomorrow it may have 90 or even 200, the number of columns will always change and I don't know how many columns it will have tomorrow, can you guide me?
it would have to be something that filters according to the informed range, something like that, some code..
Obs> Sorry for not posting this question in the thread
09-06-22 09:20 PM
|
10-06-22 09:21 AM
21-06-22 01:57 PM
Thank you very much for your explanation and for being very detailed, follow your thank you for your compliment, thank you very much