Excel Visual Basic for Applications online training

This page has 0 threads | Add post

Finding our tutorials useful? Please consider helping us to share more!

You must enable JavaScript to be able to view our online training courses (the tabbed menu below doesn't work otherwise).

Moving Around in Excel

Exercise 2.02

The aim of this exercise is to create lists of football teams by copying team names between different worksheets.

Click here to download the file needed for this exercise.

Extract and open the English Football.xlsm workbook. There are four worksheets whose name begins with 2018. Your job is to write code which populates the list of team names in column A on each of these four worksheets:

Each of the four 2018 worksheets contains a button with a subroutine attached to it.

There are four worksheets whose name begins with 2017. These sheets contain the names of the teams that you need to copy:

Each of the 2017 worksheets contains the names of the teams to copy. Some teams will be promoted or relegated to a different league in 2018.

Each subroutine in the module contains comments which tell you which team names to copy from the 2017 worksheets.

Using the comments provided, write code in each of the four subroutines to copy the correct teams from each 2017 worksheet into the correct 2018 worksheet. As a reminder, the basic code to copy and then paste the value of a cell is shown below:

Range("A1").Copy

Range("A2").PasteSpecial xlPasteValues

After writing the code, click the button on each of the 2018 worksheets and check that you have copied the correct teams into each sheet.
The answer file linked to below uses a variety of techniques to achieve the aim of the exercise. Compare your code with the answer file.
Save and close the workbook.