Moving from google sheets to Excel, need help with a formula that didn't go well with Excel.

[Procol]

Hi everyone!
I created a spreadsheet on Google Sheets and decided to move to Excel. Long story short, my spreadsheet is for sales listings, all the items for sale are in the Listings sheet, whenever an item sells, I enter the date in the Sold column and that item will automatically populate a separate sheet (monthly sheets at the bottom) based on the month that it's sold.
The formula that I was using with Google sheets is as follows: =filter(Listings!A2:M,month(Listings!B2:B)=1, Year(Listings!B2:B)=2020) I have this formula on the A2 cell of every monthly sheet (January, February etc...)
When I downloaded the file to Excel, that formula changed to this: =IFERROR(__xludf.DUMMYFUNCTION("filter(Listings!A2:M999,month(Listings!B2:B999)=1, Year(Listings!B2:B999)=2020)"),43842)
If I manually replace that formula with the first one, I get an error message "that function is not valid".
Would somebody be able to help me fix that formula or maybe change it to something else that can work?
I am using Excel 2007 version.
Thank you in advance and thanks for reading.

 

[RoryA]

OK, so if we're going with the first option, what do you actually want done?

 

[Procol]

OK, so if we're going with the first option, what do you actually want done?

As soon as I sell an item, I enter a date under the "sold" column, 2/2/2021 for example. What I want is the item that sold (the whole row) to go to the "February" tab on the bottom of the page. This way at the end of the year I will have all my sales organized by month. whether the item moves automatically or I push a button for that it doesn't really matter, a button will be cool though.
At the end of 2021, I will save a copy of the whole spreadsheet and name it 2021 and clear all the months tabs and start fresh for 2022, this way I will have all my sales organized by year.

 

[RoryA]

I think we are talking at cross-purposes. The first option was to just keep all the data on one sheet and then filter it to display whatever you want. Breaking the data out into multiple sheets will just make life much harder if you want to analyse your data.

 

[Procol]

I think we are talking at cross-purposes. The first option was to just keep all the data on one sheet and then filter it to display whatever you want. Breaking the data out into multiple sheets will just make life much harder if you want to analyse your data.

OK let's go with the first option then. I don't need anything that makes my life any harder thanks.