This is what I’m trying to do:
- Get a column in Excel that contains the word “Ticket”
- Get each value under that column
- For each value under that column I want to open a website and insert that value
I have an idea on how to approach steps 2 and 3 which would be a Read Range + For Each Row and continue with the rest of the automation I want to build. My problem is in Step 1. The column will not always be in a specific index or consistent naming convention, but it will always contain the word “Ticket” in the cell value. I’ve tried Screen Scraping the Excel work book, but I have trouble instructing the system to look for a pattern containing “Ticket” and getting the values underneath the header.