Hi Vikas,

Thanks for the response, that looks like a very promising option. What macro should i use to copy my data entry into the specific week? I understand what you have initally put which would allocate the time/date of entry to the line. But now i need to know how to sort it by appropriate date order.

Thank you for your time.

Dan