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

  • this is too broad. share a copy of your sheet and state the specific issue with an example of the desired result – user0 May 9 '19 at 7:28
  • I updated the question @user0 – kuleje May 9 '19 at 9:31

I found a way to do that by creating a simple python script using gspread

  • 1
    Hi kuleje, could you elaborate a bit? – jonsca May 11 '19 at 16:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.