KP relateret
147 delte
27 personlige Links
27 personlige Links
Learn Excel VBA and take your spreadsheets to the next level.
The first part of the course is free and can be acccessed without registering.
That gives an introduction to basic macro recording.
Alan Murray (Computergaga) shares some splendid tips - and demonstrates how to make two very useful macros.
- Protect the cells on a worksheet that contain a formula
- Consolidates data onto one worksheet (Cut and paste data to the end of a 'table')
