Thanks again for all the help, this does work except for one thing - it copies, pastes and wipes the headings as well (row 5) but i only need it to start from row 6 or 7. I've tried altering the code but it doesn't want to work... but other than that it is perfect for what i need