Declaring variables
Before confusing you with the definition of what a variable is, it helps a lot to first understand where and how variables can be used. Let's use the following example.
Imagine you are capturing data on a standard Excel spreadsheet. The fields expect users to enter their name, the department they work in, and age, all on Sheet1 of a workbook. The captured data must then be stored on a separate sheet, most likely Sheet2 of the same workbook.
The longest, most difficult way of doing that would be to copy the data from Sheet1 and paste it manually into Sheet2. It is quite clear that automation would save a lot of time.
The question is how to achieve this automation. Without some way of automatically copying and then storing that data somehow, somewhere, and then pasting it in the new position, you will never get around to doing any other work than just that.
Automation would be something like the following. You enter your details on Sheet1, and then...
