i´m trying to write a code with Python 3.10 with the following conditions:
- I have two main Spreadsheets. The first one has a list of kilometers points (column B) and the second one has a macro which needs the kilometer point to be entered.
- I would need to take the range of kilometers from the point that I decide (x), -5km.
- The values taken from the previous spreadsheet would need to be inserted in the new one in the column F from row 3 onwards.
I cannot find out how to move one by one the values from the first spreadsheet to the second one