Other Links

 

 

Tutorial on VBA for Excel (macros)

This is one of the 30 lessons from the
Tutorial on Excel Formulas

Lesson 2-7: The Camera in Excel

To develop dashboards like the one below you need a tool to assemble charts and table with variable number of columns ad rows. This tool is the camera.

Once the camera has bee activated you take pictures of tables and charts on other sheets and you assemble your dashboard. Learn how it is done in "excel-tutorial-camera.xls".