Please can someone help guide me to how I would create a macro button to paste onto a new worksheet in the next blank cell available?
To help guide my answer I m trying t copy cels C4 to Z4 on worksheet called workload and paste them onto a new worksheet called completed jobs - I can set this up no problem but once I have completed this once I want to be able to press the same button and it paste below the last set of data.
I hope I have been clear enough for some help!!Please.....
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
The usual navigation keys work with all spreadsheets. There is a set of 10 or 20 keyboard shortcuts and mouse actions which work similarly with most text editors, browsers, file mangers etc.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
I have tried to use shortcuts etc to open a new workbook and paste the data - but this doesnt seem to work! I can't use VBM and only use the record button
Ctrl+End goes to the bottom right cell of the used area
Home goes to the first cell of the same row
Down Arrow goes one row down to the first empty row
Ctrl+V pastes whatever you have in clipboard.
"doesnt seem to work!" does not give the faintest clue about your problem.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Your solution does work when I do this in the same spreadsheet. I would like to copy the data on one spreadsheetand open a different spreadsheet to paste the data - when i record the macro to do this and save it onlys copies the data and doesnt paste it into the new spreadsheet.
Why recording a macro when you can freely navigate with a few keystrokes? I would never use any macro for this trivial stuff.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
I need this as I am getting several users to add completed jobs to a master sheet - the users are not familiar with open office and my manager has asked for me to create a macro button.
I agree its very trivial but unfortunately I am just doing as I am asked.
If they can not master any spreadsheet program, you need a database solution with input forms. It is impossible to make spreadsheets "fool proof" by any means. And if you can not program, you can not have macros. Point.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
