VBA script - Multiple copies of each Row (problem).

Dear all,

My name is Alex and I am new to this forum. I have a very limited knowledge of Visual Basics, and I would be very glad if you could assist me with the following problem I have encountered.

I have an Excel database where I keep a record of all incoming calls to our organization (orders and general inquiries). In order to help me manage this database I decided to write a VBA script, which would split the entire database according to the name of the city the call was received from. There are only 4 (four) different cities in my database (these are the cities our business is operating in). Now, although my script works well (in a sense that it splits the entire database according to the city names), it has one major drawback - it creates multiple copies of each row whenever I run the script. Therefore, I was hoping that maybe someone from this community could help me to resolve this issue.

Here's my code:

Please Login or Register  to view this content.

And here's the link to the actual Excel file I am talking about.

Thank you very much in advance.

UPDATE: As far as I understand, one way of achieving the desired effect is to add one more line of code, which would add some sort of indication that this particular Row has already been Exported to the required Sheets. Hence, I could add additional Column in my database and name it "Indicator", which would store the information about the records which have already been exported. This is just a thought, if there's a better (less cluttered and efficient way) of achieving the desired effect, please let me know. Any help will be highly appreciated.