28a Multiples and factors (xlsm) - update October 2024

Update October 2024. A macro enabled spreadsheet that provides visible representations of multiples and factors.

Use drop-down menus to select integers to show factors and multiples highlighted in 1-100/1-200 number squares.

One square shows the multiples of the first integer. Another shows the multiples of the second integer. The third shows the multiples of both.
The same is shown for factors.

There are 10 sheets:
a) FactorsA - factors of all numbers from 2 up to 200. Show visibly why only integers to half-way are required
b) Factors B - factors of all numbers from 2 up to 200, colour coded showing prime and square numbers
c) F&M - factors & multiples side by side in two 1-200 number grids
d) O&E - even & odd numbers shown in a 1-200 number grid
e) PF - prime factors of three numbers as tiles
f) HCF2 - factors of two integers, showing HCF (three 1-100 grids)
b) HCF3 - factors of three integers, showing HCF (seven 1-100 grids)
c) LCM2a - multiples of two integers, showing LCM (three 1-100 grids)
d) LCM2b - multiples of three integers, showing LCM (seven 1-100 grids)
e) LCM3 - multiples of two integers, showing LCM (one 1-1050 grid)

Macros must be enabled. The sheets are protected so students/teachers can only type in integers in the correct cells. They can be easily unprotected to make changes.

I would welcome any suggestions for improvement.