Hello,
I have an excel file with various sheets, one of which contains data, the rest are graphs that are generated from data sheet. Each week I need to update a data sheet with a new data from source raw data file. I need to replace some columns starting from column M. Before column M there are formulas which will be updated when data is entered starting from column M.
I managed to do these steps but I have few more tasks to solve.
1. I need to create the output always with the new version and couldn't figure out how to do it.
2. Also I should use a new template instead of overwriting a sheet from the previous file, because number of rows might be larger in previous file. I cannot replace the sheet as some of columns in this sheet have formulas.
'
Anyone has suggestion how to do these two steps? I found in forums that I most likely need to create a bat file and use run command tool. So far I couldn't understand how to use it in this case.
