I’ve got a task that I complete each week for work, where I export data in excel from a web browser-based software and pull specific data from that workbook. I then input that data into new workbooks for specific branches of our company to compute weekly profitability reports.
Is there a way to automate this using Python where it will pull the data each week and then write it into a new copy of the profitability workbooks for each location? I’m new to Python and only want to go further if this would be possible.
Any ideas or thoughts would be extremely helpful. Thanks in advance!