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

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).

Have alook on Mod function


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