You are right

You can delete the records that you copy in the new sheet in the
same macro and use the second macro on the page to add
records again.

Or simple delete the sheet first
Add this code to the macro

On Error Resume Next
Application.DisplayAlerts = False
Sheets("Netherlands").Delete
Application.DisplayAlerts = True
On Error GoTo 0






--
Regards Ron de Bruin
http://www.rondebruin.nl


"eeboater " wrote in message ...
Thanks for the link. I have a question related to that.

After examining the contents of the link, it looks like it adds the
contents all the rows that have a particular string in the column. The
only problem I can think, is that everytime they run the script, it
will add the information to the second worksheet again. Then id begin
to get duplicate information on the second worksheet. Am I readin that
right?

Thanks,
Sean


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