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.