(Not a claim from workcover for injury or anything like that). Just a simple refund/adjustment, because of an premium assessment (adjustment). How do I enter this refund deposit in MYOB. Plus how do I take into account the stamp duty (N-T) & Insurance Premium (GST) = Refund $13.23 + GST & Stamp Duty $0.73 N-T = $15.28.
When used right, macros can save you hours by automating simple, repetitive tasks. Marcos in Excel are written in Excel VBA (Visual Basic for Applications). This is a version of Visual Basic (a prominent Microsoft programming language) developed specifically for use in Office-like applications. Creating simple macros â copy a formula from one cell to another, for instance â is fairly easy.
As we stated above, a macro is VBA code, but one of the nice things about Excel is you can create/record them with zero coding required â as we will do here. To create a macro, go to View > Macros > Record Macro. Assign the macro a name (no spaces) and click OK. Once this is done, all of your actions are recorded â every cell change, scroll action, window resize, you name it. There are a couple of places which indicate Excel is record mode.