In my case it was My Macros, Standard, Module1, and “sorta.” The spreadsheet flashed briefly and then it was sorted alphabetically by column A.Ĭreating a macro to sort by aisle was the same process, except I sorted on Column C instead of Column A and named it “sortc.” Pick the macro out of the list and push the Run button at top right. Step through the Tools menu, Macro, and Run Macro. Running the macro is even easier than creating it. Automating tasks in might just turn you into the departmental macro guru, and managers and business owners like people who can make using spreadsheets faster and easier. Why would you want to use macros? If you do repetitive jobs, like moving data around in a spreadsheet or regularly deleting old data from a column, some simple macros can save you lots of time and reduce your error rate.
Since I was sorting on the A column, I called the macro “sorta.” Move the cursor up to the upper left input box and give the new macro a reasonable name.
Click My Macros, then Standard, and finally Modules1. The recording box will close and open a menu for specifying the macro name. Click the Stop Recording button that popped up when you clicked Record Macro.Drag the mouse down to the bottom of the list, then across to include columns B and C.Left-click on the first item in column A.Click Record Macro to begin to record your keystrokes.Select the Tools menu item, then Macros.
I created a macro to sort by item name using the macro recorder: Once I’ve done that data entry, I want to sort the list from lowest to highest according to aisle (column C), filter the list so only non-zero-quantity items show up, then print the filtered list. I sort the list alphabetically by grocery item (column A), then enter the desired number of each grocery item (column B). I don’t know how some of you shoppers do it with your handwritten random lists.īefore I run my macro, I delete the quantity of each item from the previous week. I update my Calc-created grocery list spreadsheet weekly before trudging off to the store. We’ll sort a grocery list to illustrate how to build macros. The macro recorder is great, because it lets you create a macro without any programming, and when you’re done you can look at the code it built and add your own enhancements. There are two ways to create a macro in OOo. Let’s see how easy it is to create an macro and connect it to a simple pushbutton. is gaining popularity in the corporate mainstream, yet one of its most powerful features, macros, can be pretty intimidating to new users.
0 kommentar(er)
