thank you for your response.
i had thought along the same lines but because the sheet is over
written each time it is opened i.e. refreshed it would not work and is
a possible non starter.
having said that i will try it out tommorow with some data thrown in.
---
Message posted from
http://www.ExcelForum.com/