Based on dates in table, pull & sort data from "MASTER" page to individual month pages.

[Natejss]

Hi all,

I've attached an example of what I'm trying to achieve here.

I've got a master list on a page titled "MASTER List" and I'm having trouble trying to figure out how to get all and only data corresponding with the month of September to display on the "September" page of the workbook in ascending order.

I'm self taught at all of this so there are lots of holes in my knowledge and I've spent hours trying multiple different things, to no avail.

Any help will be incredibly appreciated.

[josephteh]

The simplest and error-free solution is to do a PivotTable.

With the cursor anywhere in your data > Insert > PivotTable > OK, then pull all the 3 fields to Rows section.

[FlameRetired]

Also a formula solution ....

With the target month number in cell B1 enter this formula in B3, fill down and across until you get blanks.

Please Login or Register  to view this content.

[josephteh]

Sorry, I missed the month. Attached revised file with Date field grouped by Months and pulled to Filters section.