Excel filter for pivot table

Filter for pivot table

For Each Pi In _
ActiveSheet.PivotTables(1).PivotFields(Selection.Value).PivotItems
Pi.Visible = True
Next Pi

For Each Pi In _
ActiveSheet.PivotTables(1).PivotFields(Selection.Value).PivotItems
Select Case Pi
Case "1001012", "1002113"
Pi.Visible = True
Case Else
Pi.Visible = False
End Select
Next Pi

MYOB Hotkeys

QUICK TASKS

• Ctrl+G General Journal Entry Window
• Ctrl+T To Do List
• Ctrl+Y Find Transactions
• Ctrl+H Spend Money
• Ctrl+D Receive Money
• Ctrl+J Enter Sales
• Ctrl+B Customer Payments
• Ctrl+E Enter Purchases
• Ctrl+M Supplier Payments
• Ctrl+F Cards List
• Ctrl+I Index to Reports
• Ctrl+Q Quit

EDIT MENU

• Ctrl+Z Undo
• Ctrl+X Cut
• Ctrl+C Copy
• Ctrl+V Paste
• Ctrl+A Select All
• Ctrl+L Display List
• Ctrl+R Recap Transaction

COMMAND CENTRES

• Ctrl+1 Accounts
• Ctrl+2 Banking
• Ctrl+3 Sales
• Ctrl+4 Time Billing
• Ctrl+5 Purchases
• Ctrl+6 Payroll
• Ctrl+7 Inventory
• Ctrl+8 Card File

PDF: http://www.sos4help.com.au/upimages/MYOBHotKeysv2.pdf

Accounting

Journal = 日誌 / 流水帳 / 記錄當日 dr cr 活動
Ledger = 擺放在某處方便查閱的書 / 總帳 / 內有所有帳目(accounts)
Account = 帳目 / 一個人或物件的交易 dr cr 記錄


Reference:
http://accountinginfo.com/study/je/je-01.htm
http://en.wikisource.org/wiki/1911_Encyclop%C3%A6dia_Britannica/Ledger