Hello

I'm trying to develop a Project in Excel 2010

I Want to Link 2 Tables in different Sheets.



Table in Sheet 2, has Information about a group o People set on the Time()+90 Expiring Date (highlight in Red by Excel conditional formatting).

Table in Sheet 1, should alert the User to when the Date is in Expiring Range.

The problem that I can see, is that the Array is set on a Column that has a Formula (IF Statement), and no value in the Cell.

In My Attachment, i have different solutions that I'm working on...

Sheet 2 has the Table that the User will from Time to Time inputa data

Sheet 1 has 2 Tables with different work ideias. The first goes straight to Tabel in Sheet 2 but does not exclude empty cells. The Second Table, I'm trying to make an Array that exclude cells in Sheet 2 that do not have expiring dates

I'd appriciate if somebody could give me a hand, Please!

Best Regards

Attached Files

Book1_12.xlsx (15.3 KB, 9 views)