I am trying to find out a better way for the bot to read the entire range of a column and drag a formula to the last known row. In the picture you can see that I set it to a specific range but in the future the excel will have more or less rows and I would like it to automate that process instead of me putting in the exact row numbers every month. Any suggestions?
Also, after creating a column, how can I title the header? I’ve tried type in cell activity and it will go to the wrong cell. Thank you for your help.