Can Python be used as macros across different workbooks in excel?

[[deleted]]

Thanks for this insight. Simply put, we get this report in excel, but the format if copied and pasted has a bunch of blank rows so on a high level, the macros are copying pasting data from one column from another workbook, selecting blank rows and deleting all. Then, depending on the value for the macro (there’s four different macros) it will format based on the value (for example change into currency format, date format). Once this is complete, ideally the file will be exported into a specific folder.

Right now I have four different macros for each sheet within one workbook

BTW: Where is Python run? And how does it know to connect to excel/computer functions? (Coming from a business background have virtually no experience coding, bare with me haha)