My apologies, I attached the wrong sample spreadsheet to a previous thread about this.

The correct sample sheet is attached this time.

Essentially I have an array of sales opportunities that will be purchased either this month, next month, or at some point in the future I am not sure of.

I have two worksheets, one is the Main worksheet that I use and change daily. The other is a Report worksheet which I submit to my manager each week.
The Report worksheet just has an area for Deals closing this month, and Deals closing next month.

What I would like to do is have the Report worksheet populate with the information of the deals on the Main worksheet that are marked either TM or NM from the column E drop down. TM deals should go to the Report worksheet under Deals closing this month, and NM deals should go to the Report worksheet under Deals closing next month.

Multworksheet.xlsx

Thank you.