Copy row information to another worksheet

[shingudaze]

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.

[sktneer]

Try this Array Formula. Since this is an array formula so you need to confirm it with Ctrl+Shift+Enter instead of just Enter.

In A3

Please Login or Register  to view this content.

and then drag across to D3 and down until you get blank cells.

In A15

Please Login or Register  to view this content.

and then drag across to A15 and down until you get blank cells.