Deleting records after advanced filtering

I am converting a Lotus workbook to Excel. One sheet of the workbook has an inventory listing (about 4600 line items), and there are twelve additional sheets to show sales for each of the twelve months. When an item is sold, a sales date is entered in the inventory listing. At the close of the month, a sales report for the month is prepared by advanced filtering, listing the filtered records on the proper monthly page.

Now, I want to keep the filtered records on the month sales page, go back to the inventory sheet and remove all of the records that are shown on the monthly sales report, and delete the blank rows on the invnetory sheet.

I was able to do this using Lotus, but being a newbie at Excel, I am struggling, and I am stuck. Can someone point me in the right direction. Lines of code are not required, just a gentle nudge.

You would do best to post a sample workbook showing Before and After.

It should clearly illustrate your problem and not contain any sensitive data.

In this case one typical Months data, reduced in size, and a sample Inventory Sheet should be enough.

Cheers

Now I'm really stuck.
1. How do I upload a 2 sheet dummy workbook?

2. Can the answer to my original question be as simple as running a macro that deletes the rows containing the records in the source sheet using the same criteria that the advanced filter did in getting the records to the destination sheet?

Let me ask the question another way.
Is it possible to use advanced filtering to move records from a source sheet to a destination sheet in the same workbook rather than just copying the records to the destination?