Thanks Brian,
Still cant seem to get it to work!!! Everytime I re-run the macro i
starts from row 2 in sheet1 and overwrites existing data. Is there
specific place that I should include this code?
Trefo

--
Message posted from http://www.ExcelForum.com