thank you for your help.
I have uploaded the Excel to Speedyshare. The link to download is http://speedy.sh/ukjap/HE.xlsx
I have changed the file slightly for upload from my original posting so field references are no longer accurate.
Basically what I have been trying to figure out for a very long time now is how to have Excel look at todays date +1 in row 8, check corresponding column to see if there is text in the column, if there is pull the info from those cells and put into popup automatically one day before a column that contains text is due.
For example: on July 17, one day before E4 and E1 in column AK are due, excel would trigger a popup reminder. The popup would say something like NA - HE Public Sector (field A10) + E4 (field AK 10) and NA - HE Financial (field A11) + E1 (field AK 11) are due tomorrow.
There will be many rows of data so knowing when items are due one day before via a popup would be extremely useful versus searching down the worksheet manually.
Thank You for any advise or direction on how to accomplish this, it is greatly appreciated.