WorkGuy
06-28-2023, 07:48 AM
Hi guys!
I want to try and create a module that looks through a table, compares it to another table, and then fills out all the missing information in a third table.
I've only worked with VBA recording tool up to now, so this seems like something that is way beyond my level.
Is this something that can be done? (See picture below for details)Are there any tutorials that would make this possible for me to learn, or is this very advanced?
And also - in reality there are hundreds of customers and thousands of articles. So it wouldn't be ideal to solve it without VBA...
https://preview.redd.it/gaqdask9pr8b1.png?width=1458&format=png&auto=webp&v=enabled&17c7b70230899
https://preview.redd.it/gaqdask9pr8b1.png?width=1458&format=png&auto=webp&v=enabled&17c7b702
I want to try and create a module that looks through a table, compares it to another table, and then fills out all the missing information in a third table.
I've only worked with VBA recording tool up to now, so this seems like something that is way beyond my level.
Is this something that can be done? (See picture below for details)Are there any tutorials that would make this possible for me to learn, or is this very advanced?
And also - in reality there are hundreds of customers and thousands of articles. So it wouldn't be ideal to solve it without VBA...
https://preview.redd.it/gaqdask9pr8b1.png?width=1458&format=png&auto=webp&v=enabled&17c7b70230899
https://preview.redd.it/gaqdask9pr8b1.png?width=1458&format=png&auto=webp&v=enabled&17c7b702