MM0005 - 30/12/19 - Look Up Multiple Entries In Another File

In this stream, we apply advanced coding techniques to create a powerful routine to collate data from another file according to a set of conditions.  Welcome to professional-level VBA coding!

Topics

  •  | Multiple VBA Routines vs. Single Long Routine
  •  | Switch Off But Retain Code By 'Commenting Out'
  •  | Variables - Range Variable
  •  | For Each Loop To Loop Through Cells
  •  | IF Statement - Single Line
  •  | COUNTIF
  •  | Named Range - Shorthand
  •  | Insert Breakpoint To Test Code
  •  | .Offset
  •  | Variables - Integer Variable
  •  | x = x + 1
  •  | .Offset And Variable For Position Control
  •  | Feel The Power!
1 Lesson