ham123
04-07-2019, 09:00 PM
Greetings experts,
I need help automating some data validation selection and after which, I need to automate pressing some buttons.
So I have two tables that have been embedded into cell C7 and cell C10.
Cell C7 is the product group and cell C10 is the country vendor codes.
24020
Step 1: The product group has to be selected first and then the country.
Step 2: After that, on the "Admin-Reset Status" tab, I will have to press a shape called "TIButton1" followed by "TIButton2".
Step 3: After that, on the "Send to ESC" tab, I will have to press a button called "TIButton2" followed by "TIButton1".
Step 4: The next Country has to be selected. If all the countries have been completed, then it will go to the next product group and do step 2 and 3 for all the countries. This has to be repeated until all product groups are finished.
Attached here is an example file: 24021
Any help is much appreciated! :)
I need help automating some data validation selection and after which, I need to automate pressing some buttons.
So I have two tables that have been embedded into cell C7 and cell C10.
Cell C7 is the product group and cell C10 is the country vendor codes.
24020
Step 1: The product group has to be selected first and then the country.
Step 2: After that, on the "Admin-Reset Status" tab, I will have to press a shape called "TIButton1" followed by "TIButton2".
Step 3: After that, on the "Send to ESC" tab, I will have to press a button called "TIButton2" followed by "TIButton1".
Step 4: The next Country has to be selected. If all the countries have been completed, then it will go to the next product group and do step 2 and 3 for all the countries. This has to be repeated until all product groups are finished.
Attached here is an example file: 24021
Any help is much appreciated! :)