Need help separating excel into multiple ones by column value and filtering

Help Studio
1

Hi, first time posting here.
I’m supposed to filter out even numbers in the first column of an excel, sort it out by another column and then separate it by the values of another column. I got the filter part except the formula for only returning odd numbers and in the separating part it’s giving me a error, could anyone help me out with this? (I’ve little experience with VB).

image
image745×660 18 KB

2

Have alook on Mod function

grafik

Your even number Mod 2 = 0
Your odd number Mod 2 = 1