MM0039 - 31/08/20 - Import Data From Other Files With Excel VBA

In the third stream on Tim's task, we look at moving data from other open files into a 'master' file, at the click of a button

Topics

  •  | Formulae For Generating Random Data
  •  | ROW / COLUMN
  •  | Assumptions List - Example
  •  | Importance Of Noting Assumptions
  •  | Give Customer Control With Input
  •  | Pick Out The Bits You Know First
  •  | Where Is Tim?
  •  | Conceptualising A Task - Example
  •  | Establish The File Format (Eg. .xlsm)
  •  | Good Example Of Using Worksheet Input
  •  | Importance Of ThisWorkbook
  •  | Loop Through User Inputs In A Table
  •  | How To Build Powerful Code
1 Lesson