Downloads for In Class Workbook:
In Class Week 10 Busn 214.xlsm

Downloads for Videos:
Week10Busn214StartFile
Week10Busn214FinishedFile

Macro VBlogs (click to watch):
Highline Excel Class 52: Recorded Macro Basics
Highline Excel Class 52.5: Macro Security
Highline Excel Class 53: Relative & Absolute Macro Recorder
Highline Excel Class 54: Excel VBA code From Internet

OFFSET function videos:
Excel Magic Trick 584: Dynamic Range for Periodic Data Dumps into Excel OFFSET & Defined Names
Excel Magic Trick # 158: VLOOKUP w 2 Variables As Criteria  (using OFFSET)
Excel Dynamic Chart #10: OFFSET Function Dynamic Range
 

OFFSET function workbooks:
WorkbookExcelMagicTricks582-585StartFile&FinishedFile
WorkbookExcelMagicTricks155-167StartFile
WorkbookExcelMagicTricks155-167FinishedFile
ExcelDynamicChartsSeriesStartFile
ExcelDynamicChartsSeriesFinishedFile