Translations:Faq/Calc/145/6/en
Please follow all steps :
- Copy the range containing the controls
- Create a new "work spreadsheet" containing four sheets with same names in the "initial" but with sheets "source" (B) and "target" (D) swapped:
- Paste in the sheet D of the "work" spreadsheet
- Save (you can use any name) and close the "work" spreadsheet
- Reopen the the "work" spreadsheet
- Restore the initial positions of sheets:
- Copy the range containing the controls
- Paste into the sheet D of the original spreadsheet
- Save, close, and reopen the spreadsheet.