Help in Linking Tables in different Sheets
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
|