After you execute the macro on sheets 2, 3, 4, … you will have all the data on the main sheet and all the others will have been deleted. It may be helpful to bind your macro to a keyboard shortcut. The macro recorder is unable to record the Yes response to "Are you sure you want to permanently delete the current sheet?" but you can just press the space bar to indicate Yes. This moves the data on the current sheet to beneath the data on the main (first) sheet, deletes the now empty sheet, then positions Calc on the following sheet, so one can just execute the macro again.
Shift+Command+End (Mac) / Shift+Ctrl+End (Other)Įnter σ.A1 in the Name Box, where σ represents the name of the main sheet Recorded macros have many limitations, but I think one can help here. This trick can also be used to do in-place replacement of cells with formulas with their results.Fatgreta wrote:Is it possible to combine all the data on multiple sheets within a single spreadsheet into one sheet, so I'd end up with the data showing as if I'd copied / pasted all the cells from each subsequent sheets below the cells currently in the main sheet? Writing a macro is hard, but recording one is easy. The results of formulas should be pasted now instead of the formulas.
Check only Numbers (assuming that the results are numbers). In the Paste Special dialog, under the Selection section, uncheck all the different types of selection. Right-click at the cell where you want to paste the results and choose Paste Special. To copy the results of the formulas instead of the formulas themselves, do this: This is because the formula is copied instead of the result. In LibreOffice Calc, if the cells of a spreadsheet hold the results of formulas, then those results cannot be copied and pasted to a different cell. LibreOffice Calc is the spreadsheet application in the LibreOffice suite. 📅 2012-Sep-11 ⬩ ✍️ Ashwin Nanjappa ⬩ 🏷️ copy, formula, libreoffice, libreoffice calc, paste ⬩ 📚 Archive Paste Special to paste results of formulas LibreOffice Calc: Copy and paste results of formulas
0 kommentar(er)
