I have a document that contains 31 sheet (sheets name is 1,2,3, … for each day of the month)
I created a macro at startup to select the name day (if today is Jan 10. Sheet Named selected is 10)
ThisComponent.CurrentController.ActiveSheet = ThisComponent.Sheets.getByName( format(Now(), "d"))
Now… I want to add value A1 of the previous sheet in the current sheet A1, but higher by 1
Example: in cell A1 of the current sheet, I want to be added automatically the value of the previous sheet A1, but higher by 1
‘9’.A1 = 100
'10.A1 = 101
How can make this ?
thank you in advance