I created a spreadsheet that calculates salaries for employees using a few different models of growth (different base, different rate of increase per year) . It takes a date and calculates monthly salaries for all employees.
I would like to be able to see differences over time. Right now I can do it by manually changing the date and copying the result into a separate sheet, but I'm wondering if there's a way to do it automatically, for example iterate over months and store the results somewhere.
Basically I would like to be able to iterate over different values in cell D1 and store the values of different cells such as N2, R2 or basically any others in a separate sheet or file
Best Answer
I found a way to do that by creating a simple python script using gspread