Questions Regarding UIPath Scripting

First of all these are lot of questions which should have gone to different topics to search. Anyways let me try -

Ans 1 - You can use a click activity to select Items from a dropdown or alternatively you can send hot keys to do the same here are some post what you should visit -

Ans 2 - You can use Get Text, Get Full Text, Get OCR text etc how ever after scrapping the data you will have to perform string manipulations on the result to get desired output. After this you can use Write Cell activity to write in a particular cell. Have a look here

https://studio.uipath.com/docs/output-or-screen-scraping-methods

Ans 3 - See this

Ans 4 - For this you can use write cell activity and in Excel Application scope checked a property Auto Save or you can explicitly use Save Workbook activity to save what you just write. If you write in different cells it will not overwrite. See these

In your questions I did not get this part

**How do I create activities that make it know to advance to a separate range of cells each time ongoing into the future?**

Hope rest above would help you