|
|
Using
the idea of how to open a user-from using an Excel command
button, you could create worksheets called 'Income', 'Expense',
'Capital', etc. and then create a command button for each of these
headers. Next link each command button to a macro that opens or shows
the relevant userform called 'expense', 'income', etc and you could now
enter the relevant details in the form and transfer the data to the
relevant worksheet and then finalize your profit & loss account
including depreciation! You have kind of automated your accounts in
Excel. The training video explains the first most important steps and
the other steps have been in great detail in earlier videos. |