Need help with Macro that moves row to another sheet

Hello,

Here is a macro that I've found that does almost what I need. I am hoping someone can help modify or maybe point me in the direction of where I can learn how. I am trying to move each group of duplicate row values from Column A to it's own sheet. The data in column A is never the same, it varies each time I produce the excel file. For example:

example.GIF

Here's the code I am using;

Formula:

Please Login or Register  to view this content.

What this is doing is moving everything to one sheet called duplicates. Should I just scrap this macro and rewrite it?

stcharun,
Please wrap you code. How to Edit your code:

Edit-highlight your code and click #

I've been messing with this for almost a few hours and all it seems to be doing is adding a new sheet to the workbook.

Formula:

Please Login or Register  to view this content.

Anyone have other suggestions? Anyone know of any good books I can get to help me figure this stuff out?

Audio,
What is the issue with your first code? What do you think is missing from your code, or what do you want add to your code?

Try this code

Please Login or Register  to view this content.

Thank you that did work however I dont believe I am explaining myself correctly. What I am trying to do is if you take a look at the attached workbook I am trying to move every group of different "code" from Row A and move each group to its own sheet. So for instance I want to move "001014" to a sheet, "BURFCI" to it's own sheet, and so on.TESTfile.xlsx.

If you mean creating tabs for each code on column "A", try this one.

Please Login or Register  to view this content.

Originally Posted by AB33

If you mean creating tabs for each code on column "A", try this one.

Please Login or Register  to view this content.

Thank you, I tried this but all it did was delete all the data on the sheet.

I don know if this is what you meant..

Audio,
No, the code does not delete all the sheets.
The code creates tabs for each code on column "A" from the page1 sheet. If the tab has already exists and you re-run the code, it clears the existing data on all the tabs except tab page1. The idea is that the code does not create duplication of names (Tabs) and data when you re-run it. When you run it for the first time, it will not delete any data as you have not created the tabs yet, but it creates tabs for each code. So, I do not know how when you run it for first time deletes all the sheets as there is not data or tab

I have tested renames' code and has the same result as mine, so my interpretation of your request was right.

Originally Posted by rename

I don know if this is what you meant..

Thank you Rename, this worked perfectly.

Originally Posted by rename

I don know if this is what you meant..

Is there anyway to do this without having to put it into a table?

thanks again.