Скачать или смотреть Excel VBA - Phone Book - Contact Manager - Part 2 Excel 2010

http://www.onlinepclearning.com
Excel VBA - Phone Book - Contact Manager - Phone List -- Employee Contacts - Excel 2010.This is a VBA Excel series that will develop this fantastic phone contact interface. Everything is managed from the userform. Template with the userform can be downloaded below. The VBA code will be added as we go through the tutorials.
Goal: Develop skills in application development.
Features
Filter contacts by all headings
Filter by full or part references
Data is auto sorted
Add data is indexed so no duplicates
Add new contacts from the form
Delete contacts
Edit all or part of the database
What will we learn?
Recording macros
Working with variables
Functions /IF / SORT / OFFSET
Variable advanced filters
Copy and paste without selecting
Application logic