I'm developing a procurement report that given a specific scenario, the VBA will count the number of occurences within a given column and provide me a number of records which match this criteria, it would also be helpful if the VBA could provide a list of the records which match the criteria.

Example: I want an IF function in VBA that will search the "W" column for an "x", if it is empty, I would like it count all the occurences of "180 Days" in column X and then provide that number on Sheet1 into a cell and under it a reference to the content that is in the respective D column (which will show the name of the contract).

Here's the part that has be perplexed, I haven't figured out a way to not get redundancy from the reports. The cells X through AA in record 11 will show up on all respective reports, I only need it to appear once: in the 30 days report as it is set to expire within 30 days.

Here's what it looks like:
Name: delete100.PNG Views: 415 Size: 16.3 KB

Here's what I'm trying to accomplish:
Name: delete101.jpg Views: 405 Size: 16.4 KB

If you have any suggestions or a way to simplify what I'm requesting of your abilities, please provide anything, I'm open to learning.

Thanks in advance.