Creating a filtered populated list from another tab

[Uvuriel03]

My spreadsheet is here: Commission Sheet 041013 3.xlsx.

I need the area under "Spiffs/Other" to be populated by the Spiff Breakdown tab, based on the month at the top of the Printable Sheet tab (E1).

So for July, it would display the Sold leftover soap and the Employee of the Month bonus.

I'm still figuring out which columns I would like to be displayed. I think B:E will be merged and will display the Description, and F will display the Amt Paid, but I'm not 100% certain yet.

Thank you!!

[tigeravatar]

Uvuriel03,

Attached is a modified version of your posted workbook.
In sheet 'Printable Sheet' cell B30 and copied down is this formula:

Please Login or Register  to view this content.

Then in sheet 'Printable Sheet' cell D29 I typed in the header Amt Paid
In D30 and copied down is this formula:

Please Login or Register  to view this content.

Does that work for you?