I've been actively looking for a solution for the question above. I want to know if there is a script or package that allows me to automate a new column in my excel sheet every week.
Ex. I have a master Excel sheet that has columns labeled as weeks from 1-14 with data within all of them. I get a new sheet every week from a 3rd party, so i would get an excel sheet for week 15, and I would have to create a new column in my master sheet every time & copy and paste. It's tedious work because I have to copy and paste to a variety of different excel sheets. Anyway anyone can help? I am greatly appreciative!