MM0008 - 20/01/20 - VBA To Move Input Data To A Database

This is a common task in Excel VBA - transferring data from a 'form' (a userform or a sheet in the file) to a database.  Chris demonstrates the cool technique he uses on real-world projects.

Topics

  •  | Basic Setup For Moving Data Around
  •  | Basic Setup For Moving Data Around
  •  | Transpose Data
  •  | Importance Of Consistent Layout Across Sheets
  •  | Make Things Clear … For Yourself!
  •  | ROW
  •  | COLUMN
  •  | Discussion Of .Cells vs. Offset Pros And Cons
  •  | Range(Range,Range)
  •  | .end(xldown)
  •  | Why We Love Dynamic Solutions
  •  | For Each Loop Example
  •  | .Address
  •  | .Cells
  •  | Discussion Of Direct vs. Remote Coding 
  •  | .Offset
1 Lesson