I have an excel sheet with a drop-down list. The list is always in cell B20. There are around 30 items in the list.
Each time you click a new item - new data is generated on the sheet. So what I want to do is click each item, then export the sheet to a PDF file. Then repeat this process for all 30 items in the list (so I will have 30 PDF files when done).
Does anyone have any advice on how to get the bot the click each item in the list? I was thinking a recording with click activity but how would it scroll down the list?