Hi All
basically i have source code (complied through MS Query - sheet1) which is a complete list of status (codes) changes in a case which contains: -
date of change
To and From i.e. LIP to VA on 26th July 2011 in descending order
I have a summary sheet which contains the case number, current code, then end of month dates which will continous change everytime it loads (i know that the formula to work the end of month is not that accurate but i will complete that another time).
What i want to do is complete these end of month dates on the summary sheet with the code closest to the end of month date if at all possible?
im seeing a few problems thou that a status could update in may but i need it to show that update then in every subsquental month
i have uploaded a sample document below
http://www.megaupload.com/?d=8KZI4TNF
basically i have source code (complied through MS Query - sheet1) which is a complete list of status (codes) changes in a case which contains: -
date of change
To and From i.e. LIP to VA on 26th July 2011 in descending order
I have a summary sheet which contains the case number, current code, then end of month dates which will continous change everytime it loads (i know that the formula to work the end of month is not that accurate but i will complete that another time).
What i want to do is complete these end of month dates on the summary sheet with the code closest to the end of month date if at all possible?
im seeing a few problems thou that a status could update in may but i need it to show that update then in every subsquental month
i have uploaded a sample document below
http://www.megaupload.com/?d=8KZI4TNF
